Search
Hall of Fame
About Us
All Questions
New Question
Login
C#
VB
ASP.NET
XAML
WCF
LINQ
SQL
IIS
Excel
Word
Access
SharePoint
SQL
Windows 7
All 76 Topics
Biography - Pichart Y.
Work: Retail business. There are always new things to know in excel. "With sharing what I know with others, then I get many new things from them in return".
0
Replies
re: Do while loop
( 0 views ) Submitted By
Pichart Y.
on 02-Apr-13 05:17 AM in
Microsoft Excel
.
2
Replies
re: Do while loop
( 2 views ) Submitted By
Pichart Y.
on 16-Mar-13 09:03 PM in
Microsoft Excel
.
2
Replies
re: Do while loop
( 2 views ) Submitted By
Pichart Y.
on 14-Mar-13 05:21 AM in
Microsoft Excel
.
1
Reply
re: Do while loop
( 1 views ) Submitted By
Pichart Y.
on 13-Mar-13 11:13 PM in
Microsoft Excel
.
0
Replies
re: Found value in quotes not matching cell value without quotes, VBA Excel
( 0 views ) Submitted By
Pichart Y.
on 11-Feb-13 08:37 PM in
Microsoft Excel
.
1
Reply
re: Reformat a table using VBA
( 1 views ) Submitted By
Pichart Y.
on 11-Feb-13 12:26 AM in
Microsoft Excel
.
0
Replies
re: Macro to Identify cells containing 1 of Top 10 values in range, without sorting
( 0 views ) Submitted By
Pichart Y.
on 10-Feb-13 09:03 AM in
Microsoft Excel
.
1
Reply
re: Reformat a table using VBA
( 1 views ) Submitted By
Pichart Y.
on 09-Feb-13 11:08 AM in
Microsoft Excel
.
0
Replies
re: VBA code to insert line is not working
( 0 views ) Submitted By
Pichart Y.
on 31-Jan-13 02:51 AM in
Microsoft Excel
.
1
Reply
re: VBA code to insert line is not working
( 1 views ) Submitted By
Pichart Y.
on 30-Jan-13 03:51 AM in
Microsoft Excel
.
0
Replies
re: Copy rows from onesheet to another
( 0 views ) Submitted By
Pichart Y.
on 26-Oct-12 12:47 PM in
Microsoft Excel
.
0
Replies
re: Excel 2007 Data Validation question - need to lock part of a SS until a requirement's met
( 0 views ) Submitted By
Pichart Y.
on 05-Oct-12 12:07 PM in
Microsoft Excel
.
1
Reply
re: Excel 2007 Data Validation question - need to lock part of a SS until a requirement's met
( 1 views ) Submitted By
Pichart Y.
on 05-Oct-12 10:11 AM in
Microsoft Excel
.
1
Reply
re: Excel 2007 Data Validation question - need to lock part of a SS until a requirement's met
( 1 views ) Submitted By
Pichart Y.
on 30-Sep-12 02:55 AM in
Microsoft Excel
.
0
Replies
re: how to Add 257th Column in 2003 MS-Excel Sheet ?
( 0 views ) Submitted By
Pichart Y.
on 21-Aug-12 09:07 AM in
Microsoft Excel
.
0
Replies
re: how to run a macro by pressing a particular key in VBA?
( 0 views ) Submitted By
Pichart Y.
on 11-Aug-12 10:35 PM in
Microsoft Excel
.
1
Reply
re: Can you combine 2 sumifs?
( 1 views ) Submitted By
Pichart Y.
on 04-Aug-12 12:05 AM in
Microsoft Excel
.
1
Reply
re: how do I create a formula that would sum 2 figures and then round up to a specific number
( 1 views ) Submitted By
Pichart Y.
on 03-Aug-12 11:46 PM in
Microsoft Excel
.
0
Replies
re: How do you get rid of the extra lines when downloading BNA Fixed Asset reports
( 0 views ) Submitted By
Pichart Y.
on 25-Jul-12 10:28 PM in
Microsoft Excel
.
0
Replies
re: Formula to show result in different cell
( 0 views ) Submitted By
Pichart Y.
on 25-Jul-12 10:24 PM in
Microsoft Excel
.
1
Reply
re: Formula to show result in different cell
( 1 views ) Submitted By
Pichart Y.
on 25-Jul-12 01:25 AM in
Microsoft Excel
.
0
Replies
re: Sum of Amount(amount diff for each p/d) based on which time frame the pay date falls.
( 0 views ) Submitted By
Pichart Y.
on 14-Jul-12 09:00 PM in
Microsoft Excel
.
0
Replies
re: Sum of Amount(amount diff for each p/d) based on which time frame the pay date falls.
( 0 views ) Submitted By
Pichart Y.
on 14-Jul-12 08:54 PM in
Microsoft Excel
.
1
Reply
re: Sum of Amount(amount diff for each p/d) based on which time frame the pay date falls.
( 1 views ) Submitted By
Pichart Y.
on 13-Jul-12 03:28 AM in
Microsoft Excel
.
0
Replies
re: How to populate a section of cells based on selections made in cascading drop boxes
( 0 views ) Submitted By
Pichart Y.
on 11-Jul-12 11:34 PM in
Microsoft Excel
.
0
Replies
re: Please Help...........!!!!
( 0 views ) Submitted By
Pichart Y.
on 08-Jul-12 12:17 PM in
Microsoft Excel
.
0
Replies
re: How do I change the printing of a defined range from 1/4 sheet to full sheet?
( 0 views ) Submitted By
Pichart Y.
on 06-Jul-12 12:19 AM in
Microsoft Excel
.
0
Replies
re: How to add a single quote infront of the column in excel ?
( 0 views ) Submitted By
Pichart Y.
on 30-Jun-12 03:39 AM in
Microsoft Excel
.
1
Reply
re: pivot table or formula
( 1 views ) Submitted By
Pichart Y.
on 28-Jun-12 10:08 AM in
Microsoft Excel
.
0
Replies
re: excel problem
( 0 views ) Submitted By
Pichart Y.
on 27-Jun-12 12:37 PM in
Microsoft Excel
.
1
Reply
re: excel problem
( 1 views ) Submitted By
Pichart Y.
on 26-Jun-12 11:44 AM in
Microsoft Excel
.
0
Replies
re: ecxel problem
( 0 views ) Submitted By
Pichart Y.
on 26-Jun-12 11:40 AM in
Microsoft Excel
.
1
Reply
re: Match data sequence based on Date sheet Column A ,B
( 1 views ) Submitted By
Pichart Y.
on 26-Jun-12 11:26 AM in
Microsoft Excel
.
1
Reply
re: exhell 2007 corrupts an xls when it opens it ("Unreadable Content..")
( 1 views ) Submitted By
Pichart Y.
on 26-Jun-12 10:24 AM in
Microsoft Excel
.
1
Reply
re: Match data sequence based on Date sheet Column A ,B
( 1 views ) Submitted By
Pichart Y.
on 26-Jun-12 04:21 AM in
Microsoft Excel
.
1
Reply
re: exhell 2007 corrupts an xls when it opens it ("Unreadable Content..")
( 1 views ) Submitted By
Pichart Y.
on 26-Jun-12 04:02 AM in
Microsoft Excel
.
1
Reply
re: Match data sequence based on Date sheet Column A ,B
( 1 views ) Submitted By
Pichart Y.
on 26-Jun-12 02:54 AM in
Microsoft Excel
.
2
Replies
re: Match data sequence based on Date sheet Column A ,B
( 2 views ) Submitted By
Pichart Y.
on 25-Jun-12 11:08 AM in
Microsoft Excel
.
1
Reply
re: Macros for Formatting Cells
( 1 views ) Submitted By
Pichart Y.
on 25-Jun-12 11:05 AM in
Microsoft Excel
.
0
Replies
re: Excel VBA: If statement using formula to find the variance in the subtotal row.
( 0 views ) Submitted By
Pichart Y.
on 25-Jun-12 10:37 AM in
Microsoft Excel
.
1
Reply
re: Need experts solutions in 2 excel problems
( 1 views ) Submitted By
Pichart Y.
on 25-Jun-12 10:32 AM in
Microsoft Excel
.
0
Replies
re: Need experts solutions in 2 excel problems
( 0 views ) Submitted By
Pichart Y.
on 25-Jun-12 07:08 AM in
Microsoft Excel
.
0
Replies
re: Excel VBA: If statement using formula to find the variance in the subtotal row.
( 0 views ) Submitted By
Pichart Y.
on 24-Jun-12 10:58 PM in
Microsoft Excel
.
0
Replies
re: Need experts solutions in 2 excel problems
( 0 views ) Submitted By
Pichart Y.
on 24-Jun-12 10:50 PM in
Microsoft Excel
.
0
Replies
re: Excel VBA: If statement using formula to find the variance in the subtotal row.
( 0 views ) Submitted By
Pichart Y.
on 21-Jun-12 09:13 PM in
Microsoft Excel
.
1
Reply
re: Search string in column similar then sum the data and result next sheet
( 1 views ) Submitted By
Pichart Y.
on 20-Jun-12 11:41 AM in
Microsoft Excel
.
0
Replies
re: Converting text cells to numbers
( 0 views ) Submitted By
Pichart Y.
on 20-Jun-12 10:25 AM in
Microsoft Excel
.
0
Replies
re: horizontal (catagory) axis labels; EDIT Tab=Dimmed...how do I make it ACTIVE?
( 0 views ) Submitted By
Pichart Y.
on 20-Jun-12 10:19 AM in
Microsoft Excel
.
1
Reply
re: Converting text cells to numbers
( 1 views ) Submitted By
Pichart Y.
on 20-Jun-12 06:23 AM in
Microsoft Excel
.
0
Replies
re: Converting text cells to numbers
( 0 views ) Submitted By
Pichart Y.
on 20-Jun-12 02:09 AM in
Microsoft Excel
.
2
Replies
re: Auto fill day of the week
( 2 views ) Submitted By
Pichart Y.
on 19-Jun-12 09:20 PM in
Microsoft Excel
.
1
Reply
re: Search string in column similar then sum the data and result next sheet
( 1 views ) Submitted By
Pichart Y.
on 19-Jun-12 09:14 PM in
Microsoft Excel
.
0
Replies
re: SUMIF Formula Help
( 0 views ) Submitted By
Pichart Y.
on 19-Jun-12 05:39 AM in
Microsoft Excel
.
0
Replies
re: Help on Macros to be used for Conditional Formatting of cells
( 0 views ) Submitted By
Pichart Y.
on 18-Jun-12 11:55 AM in
Microsoft Excel
.
1
Reply
re: Macros for Formatting Cells
( 1 views ) Submitted By
Pichart Y.
on 18-Jun-12 11:54 AM in
Microsoft Excel
.
0
Replies
re: Excel - Macros for Formatting of Cells.
( 0 views ) Submitted By
Pichart Y.
on 18-Jun-12 11:21 AM in
Microsoft Excel
.
0
Replies
re: Is it me?
( 0 views ) Submitted By
Pichart Y.
on 14-Jun-12 09:08 PM in
Microsoft Excel
.
1
Reply
re: Excel Formula
( 1 views ) Submitted By
Pichart Y.
on 14-Jun-12 10:03 AM in
Microsoft Excel
.
1
Reply
re: Excel Formula
( 1 views ) Submitted By
Pichart Y.
on 13-Jun-12 11:17 AM in
Microsoft Excel
.
1
Reply
re: Excel Formula
( 1 views ) Submitted By
Pichart Y.
on 12-Jun-12 09:42 PM in
Microsoft Excel
.
0
Replies
re: Can you use a count if formula to sum up certain coloured cells in a range?
( 0 views ) Submitted By
Pichart Y.
on 12-Jun-12 07:28 PM in
Microsoft Excel
.
1
Reply
re: data analysis
( 1 views ) Submitted By
Pichart Y.
on 12-Jun-12 11:13 AM in
Microsoft Excel
.
1
Reply
re: Report to be generated using multiple conditions
( 1 views ) Submitted By
Pichart Y.
on 12-Jun-12 11:11 AM in
Microsoft Excel
.
0
Replies
re: Suitable Formula Need
( 0 views ) Submitted By
Pichart Y.
on 12-Jun-12 11:05 AM in
Microsoft Excel
.
2
Replies
re: Excel Formula
( 2 views ) Submitted By
Pichart Y.
on 12-Jun-12 04:57 AM in
Microsoft Excel
.
0
Replies
re: rolling 12 months data
( 0 views ) Submitted By
Pichart Y.
on 11-Jun-12 11:38 AM in
Microsoft Excel
.
0
Replies
re: Can you use a count if formula to sum up certain coloured cells in a range?
( 0 views ) Submitted By
Pichart Y.
on 11-Jun-12 11:00 AM in
Microsoft Excel
.
1
Reply
re: Can you use a count if formula to sum up certain coloured cells in a range?
( 1 views ) Submitted By
Pichart Y.
on 11-Jun-12 09:22 AM in
Microsoft Excel
.
1
Reply
re: Excel Formula
( 1 views ) Submitted By
Pichart Y.
on 11-Jun-12 06:28 AM in
Microsoft Excel
.
1
Reply
re: Report to be generated using multiple conditions
( 1 views ) Submitted By
Pichart Y.
on 11-Jun-12 01:36 AM in
Microsoft Excel
.
1
Reply
re: Report to be generated using multiple conditions
( 1 views ) Submitted By
Pichart Y.
on 10-Jun-12 06:56 AM in
Microsoft Excel
.
1
Reply
re: Excel Formula
( 1 views ) Submitted By
Pichart Y.
on 10-Jun-12 06:48 AM in
Microsoft Excel
.
0
Replies
re: rolling 12 months data
( 0 views ) Submitted By
Pichart Y.
on 09-Jun-12 07:18 AM in
Microsoft Excel
.
0
Replies
re: rolling 12 months data
( 0 views ) Submitted By
Pichart Y.
on 09-Jun-12 07:17 AM in
Microsoft Excel
.
0
Replies
re: Data Import From Web
( 0 views ) Submitted By
Pichart Y.
on 09-Jun-12 01:02 AM in
Microsoft Excel
.
1
Reply
re: data analysis
( 1 views ) Submitted By
Pichart Y.
on 08-Jun-12 10:49 PM in
Microsoft Excel
.
0
Replies
re: data analysis
( 0 views ) Submitted By
Pichart Y.
on 06-Jun-12 09:37 PM in
Microsoft Excel
.
1
Reply
re: ecxel problem
( 1 views ) Submitted By
Pichart Y.
on 06-Jun-12 02:21 AM in
Microsoft Excel
.
0
Replies
re: Desidero Ringraziarti Tantissimo Pichart Y
( 0 views ) Submitted By
Pichart Y.
on 05-Jun-12 01:25 PM in
Microsoft Excel
.
0
Replies
re: Ranking Agents in a Spreadsheet
( 0 views ) Submitted By
Pichart Y.
on 02-Jun-12 12:09 AM in
Microsoft Excel
.
1
Reply
re: Ranking Agents in a Spreadsheet
( 1 views ) Submitted By
Pichart Y.
on 01-Jun-12 12:23 AM in
Microsoft Excel
.
1
Reply
re: Il Mio progetto Come da Vopi Gentilmente Richiesto
( 1 views ) Submitted By
Pichart Y.
on 31-May-12 11:12 AM in
Microsoft Excel
.
0
Replies
re: Cerco Aiuto per Riuscire a Risolvere questo Problema
( 0 views ) Submitted By
Pichart Y.
on 31-May-12 06:08 AM in
Microsoft Excel
.
0
Replies
re: Lookup Cell Above / Below
( 0 views ) Submitted By
Pichart Y.
on 30-May-12 11:45 AM in
Microsoft Excel
.
1
Reply
re: Lookup Cell Above / Below
( 1 views ) Submitted By
Pichart Y.
on 30-May-12 11:27 AM in
Microsoft Excel
.
0
Replies
re: how to create a mark up in a single cell
( 0 views ) Submitted By
Pichart Y.
on 30-May-12 11:22 AM in
Microsoft Excel
.
1
Reply
re: Lookup Cell Above / Below
( 1 views ) Submitted By
Pichart Y.
on 30-May-12 10:59 AM in
Microsoft Excel
.
0
Replies
re: Macro + Notepad
( 0 views ) Submitted By
Pichart Y.
on 26-May-12 05:25 AM in
Microsoft Excel
.
1
Reply
re: data analysis
( 1 views ) Submitted By
Pichart Y.
on 26-May-12 04:31 AM in
Microsoft Excel
.
0
Replies
re: 6 golfers playing 6 rounds of golf over 6 days
( 0 views ) Submitted By
Pichart Y.
on 26-May-12 03:51 AM in
Microsoft Excel
.
1
Reply
re: data analysis
( 1 views ) Submitted By
Pichart Y.
on 25-May-12 12:47 PM in
Microsoft Excel
.
1
Reply
re: Excel functions
( 1 views ) Submitted By
Pichart Y.
on 25-May-12 12:33 PM in
Microsoft Excel
.
1
Reply
re: HOW CAN I COPY INTERIOR COLOR FROM A CELL FOUND WITH VLOOKUP
( 1 views ) Submitted By
Pichart Y.
on 24-May-12 01:45 PM in
Microsoft Excel
.
0
Replies
re: Duplicate files found
( 0 views ) Submitted By
Pichart Y.
on 22-May-12 09:03 PM in
Windows XP
.
1
Reply
re: data analysis
( 1 views ) Submitted By
Pichart Y.
on 22-May-12 12:03 PM in
Microsoft Excel
.
1
Reply
re: data analysis
( 1 views ) Submitted By
Pichart Y.
on 22-May-12 10:42 AM in
Microsoft Excel
.
2
Replies
re: data analysis
( 2 views ) Submitted By
Pichart Y.
on 21-May-12 11:47 PM in
Microsoft Excel
.
0
Replies
re: Sum with Period of Date (sum during a date period)
( 0 views ) Submitted By
Pichart Y.
on 20-May-12 04:15 AM in
Microsoft Excel
.
0
Replies
re: Formula error - Cell contains a constant
( 0 views ) Submitted By
Pichart Y.
on 19-May-12 10:12 PM in
Microsoft Excel
.
3
Replies
re: Formula error - Cell contains a constant
( 3 views ) Submitted By
Pichart Y.
on 19-May-12 03:41 PM in
Microsoft Excel
.
1
2
3
4
5
6
7
8
9
10
Next
Last
ODBC Drivers for QuickBooks, Salesforce, SAP, MSCRM, SharePoint … Free Trial!