|
|
|
|
2 |
88 |
|
|
#Adding new worksheet problem by
Sandeep Lohchab
Sir,
How to add new worksheet on right side of current selected worksheet? When I
press Shift+F11, new worksheet comes on left side, but I want it to appear...
|
|
2 |
106 |
|
|
Sumif Format Equals by
Starbuck82
I have both dates and currency in the same column. How do I sum the column
based on format of the cell? Specifically, how do I sumif only the cells...
|
|
3 |
107 |
|
|
Using the Address Function by
Space Elf
I need to get data from several workbooks so I often use the
"INDIRECT(ADDRESS" function and reference a variable in a cell for the
worksheet name.
Now I am...
|
January 14th, 2010 01:37 PM
by Clarity
|
1 |
79 |
|
|
|
|
3 |
119 |
|
|
Conditional Format Q by
Seanie
I wish to create a conditional format formula that will change the
background colour in a cell to Blue, if the value of another cell is
between to values...
|
January 14th, 2010 12:31 PM
by Seanie
|
4 |
81 |
|
|
Paste Values Based on Conditional Value by
Don[_23_]
I have a workbook with 2 worksheets. Basically it is a daily sales
log. On worksheet 1 the user will input multiple daily sales figures
and the date. ...
|
|
0 |
86 |
|
|
|
|
5 |
85 |
|
|
|
|
1 |
88 |
|
|
Data extract by
Brad Autry
Greetings,
I need a date for specific product purchase. The data provided me was
arranged as follows:
Customer IDs in column A.
Subsequent columns are...
( 1 2)
|
January 14th, 2010 08:46 AM
by minyeh
|
10 |
153 |
|
|
Excel formula request by
Stan
I have column A. In Column b i have a formula that selects column a acording
to specific parameters.
Then I want to sort column b, which has some of column A...
|
|
1 |
96 |
|
|
|
|
0 |
88 |
|
|
|
|
1 |
84 |
|
|
Adding data to a 2007 pivot table by
Dianeg
Hi
sorry if this is a stupid question, how do I add refresh a pivot table to
include data added to the END of my existing data? Do you have to recreate
the...
|
|
2 |
97 |
|
|
What if analysis icon is not available by
KMN
My class is working with Goal Seek. They go to the Data tab and most of the
icons are gray shaded and can't be clicked on. One of them is the What If...
|
|
2 |
108 |
|
|
|
|
1 |
133 |
|
|
Determine if 2 cells share a common word by
paul c
I have a list with two text columns. I want to identify the rows where the
cells share a common word. For example,
Fujitsu Consulting in col A and Software...
|
|
2 |
110 |
|
|
|
|
4 |
139 |
|
|
Nested MID and FIND - OR? by
Brenda
Hello all!
Does anyone know how I may be able to search a string and extract text from
it using the MID and FIND function with multiple FINDS? I have a...
|
January 14th, 2010 01:58 AM
by Pete_UK
|
3 |
115 |
|
|
Tab Key by
kessler
I have created a worksheet with locked and unlocked cells. When I protect
the sheet, the cursor will tab nicely through the unlocked cells until I get
to a...
|
|
1 |
84 |