|
|
Missing Record in Table Lookup by
Jim
I'm using Excel 2007.
I have created a table with customer numbers, names, status, and several
other columns. I named this table including the header row...
|
March 25th, 2010 04:58 AM
by Jim
|
0 |
141 |
|
|
|
|
5 |
126 |
|
|
find by
cmkwolf
I am trying to set up a worksheet at work that lists case numbers in the
following format ab12345 how do i do a search for a specific case and I want
to...
|
March 25th, 2010 03:21 AM
by FSt1
|
1 |
154 |
|
|
Vlookup possibly ? by
Steve
I have this data in rows C, & L thru P. In C6, if I manually enter a 3,
I need the data in row 17 to populate row 11 as shown (L11="",
M11="",N11=-972,...
|
March 25th, 2010 02:04 AM
by Pete_UK
|
3 |
123 |
|
|
Looking for Text strings by
Scats
I lost all my data and have to redo my home spreadsheet, but It's been awhile
since I made it and I have forgotten some of my formulas. I need a simple one...
|
March 24th, 2010 11:38 PM
by Scats
|
3 |
147 |
|
|
|
March 24th, 2010 10:33 PM
by ker_01
|
1 |
131 |
|
|
Excell Spreedsheets by
Jack Wheeler
I have thee monitors running at one time. How can I work on two Excell
spreadsheets at a time and be able to run one on one monitor and the second
on another...
|
March 24th, 2010 10:15 PM
by Tony
|
1 |
208 |
|
|
Circular Reference Warning ??? by
Soth
Hi
I receive a this message 'Circular Reference Warning'...One or more formulas
cantian circula reference and may not calculate correctly.
How is this...
|
|
1 |
170 |
|
|
Indirect and Sheet Name by
Rob
I have a formula =COUNTA(INDIRECT(A3)) which returns the count of items in a
range which is defined in cell A3, the formula in A3 is below. Is there a
way...
|
March 24th, 2010 08:56 PM
by Rob
|
4 |
148 |
|
|
mark up by
arKwelder
need to mark up 16800 items by 15% column e is my net and need column f
with new prices
|
|
3 |
117 |
|
|
|
|
1 |
138 |
|
|
Downward column by
climate
Hi
suppose that,my data set on column x and second row(x2),i want to move this
column to desired row.
For example: data position is x2 and expected position...
|
March 24th, 2010 08:01 PM
by climate
|
1 |
137 |
|
|
Pivot Table Refresh by
Eric
I believe there is a way to create a button to refresh multiple pivot tables
within the same file, but I can't seem to figure it out.
I'm creating a model...
|
March 24th, 2010 07:55 PM
by Eric
|
5 |
148 |
|
|
|
|
12 |
281 |
|
|
Pivot Table - Calculated Field by
Mike C
I have 3 fields, Building, Employee, and Sales. I have about 3,000 records in
total.
I can run a simple pivot table to show by building which counts the...
|
|
2 |
113 |
|
|
|
March 24th, 2010 07:17 PM
by Meg
|
0 |
138 |
|
|
|
|
2 |
128 |
|
|
|
|
4 |
123 |
|
|
|
March 24th, 2010 06:31 PM
by DG
|
4 |
122 |
|
|
|
March 24th, 2010 06:09 PM
by Eduardo
|
5 |
208 |