|
|
|
April 16th, 2009 11:04 PM
by ladygr
|
3 |
80 |
|
|
Alternative to using 10 V-lookup formulas by
Tami
I have table with sales data.
The user types in the classes they want to sum....they can type up to 10
classes.
How can I avoid having to write a formula to...
|
|
3 |
96 |
|
|
|
April 16th, 2009 09:52 PM
by murph
|
4 |
87 |
|
|
|
|
5 |
123 |
|
|
Text into Columns by
tcmh
For some reason I cannot accomplish this function - I use the menu drop down
Text to Columns, I choose Delimited, Next, comma (although there are spaces
at...
|
|
3 |
115 |
|
|
combining data from multiple workbooks by
dslocum
I have put together a spreadsheet for our customer service department to track the TYPES of support phone calls they receive. Each customer rep has their own...
|
|
6 |
139 |
|
|
|
|
6 |
65 |
|
|
|
|
3 |
78 |
|
|
COUNTING by
Connie Martin
I have research Help and online. I've done a pile of reading and
experimenting, but nothing works. I know it's got to be simple, but finding
the answer...
|
|
4 |
112 |
|
|
Can't save Excel spreadsheets by
Claire
I have spreadsheets on an external drive (GS Drive L:). I access the info on
this "thumbdrive" on two computers, one desktop and one laptop. If I try to...
|
April 16th, 2009 08:36 PM
by Kassie
|
1 |
83 |
|
|
Help with VLOOKUP & MATCH formula by
GoBucks
I am looking for help with creating a lookup formula with multiple
conditions. In Sheet1 I have the following table with B2:E2 being the header...
|
April 16th, 2009 08:31 PM
by GoBucks
|
5 |
130 |
|
|
|
|
7 |
152 |
|
|
Current Cell location by
HRHRLBS
I am trying to use an OFFSET lookup command but need to tell the formula the
current location within the column. What formula displays my current cell...
|
April 16th, 2009 07:38 PM
by Mike H
|
1 |
83 |
|
|
Percentage over a date range by
CP
In row 1 I have Jan to Dec - a header row
in row 2 I have a value directly under each date cell - the amount per month
in row 3 I need the percentage value of...
|
April 16th, 2009 05:46 PM
by Eduardo
|
3 |
81 |
|
|
|
|
1 |
79 |
|
|
|
|
2 |
69 |
|
|
|
April 16th, 2009 05:33 PM
by Mike H
|
2 |
108 |
|
|
|
|
11 |
135 |
|
|
data associated with latest date by
tcek
I have two columns. Column one has the dates of the month and the second
column has inventory amounts for that date. The inventory amounts is paste
linked...
|
April 16th, 2009 05:07 PM
by tcek
|
5 |
105 |
|
|
|
|
33 |
349 |