|
|
Functions on filtered data by
LiAD
Afternoon,
I have an excel sheet of 10 cols and 200 rows on sheet 1.
Sheet 2 has a table which searches through the list of data in sheet 1 to
1 - produce a...
|
|
1 |
127 |
|
|
reference cell from advanced filter by
Nathan
I'm sure this is slam dunk, but I can't figure it out :)
On worksheet 1, I have executed an Advanced filter of 900 rows, to get down
to one row. No...
|
|
3 |
157 |
|
|
First Day of the month by
Jen_T
Does anyone know how to have excel look at a cell that has a date that is
formatted as xx/xx/xxxx (E.g. Cell A2 = 01/16/2007) and show the date as...
|
|
3 |
145 |
|
|
convert vertical to horizontal by
Mona
I see lots of post but not one I can use. I am looking for a "function" that
will take vertical data to horizontal. I don't want the copy,paste,
transpose...
|
|
6 |
175 |
|
|
sorting data by
Hellomoto
I have a column of data that repeats every 10 rows. that is, the data type
is repeated every ten rows. I want to reorganize the data in that column into
10...
|
|
2 |
138 |
|
|
excel dates by
king2385
how do i change #(1-365) to the corresponding date in excel?
|
|
1 |
131 |
|
|
Collecting data from Excel form by
Ricki Miles
I am working in Excel 2003 and would like to know if there is a way to
create a form for data fill-in so that the data would then be collected in a
database...
|
|
2 |
174 |
|
|
Formula Question by
Tony
Was wondering if there is an IFcount formula for this scenario?
Below on Sheet 1
A B C
1 125 58 183
2 896 876 20
3 500 11 511
4 244 5 249
|
March 25th, 2010 10:36 PM
by Tony
|
4 |
213 |
|
|
|
March 25th, 2010 10:34 PM
by Ziggy
|
4 |
188 |
|
|
Sumproduct with Multiple Criteria by
JeffTO[_2_]
Hi All
I have a question which I cant figure out - I use Sumproduct alot to
sum up multiple criteria and it works well in most situations
I have no problem...
|
|
2 |
133 |
|
|
|
March 25th, 2010 10:03 PM
by JoeM
|
0 |
111 |
|
|
|
|
5 |
179 |
|
|
Removing ''VALUES'' by
Mark D
Hi Again (where would I be without the help from this board)
I have a forumula in a cell as follows
=IF(ISNA(VLOOKUP($A77,'Personal NFI...
|
March 25th, 2010 09:13 PM
by Ziggy
|
5 |
142 |
|
|
Use vlookup within offset? by
berniean
Can I use a vlookup within an offset formula to define the reference? I want
to find a value in a column on a tab, go down one, and record the anwser.
On...
|
|
4 |
143 |
|
|
|
|
13 |
308 |
|
|
adding result of "if" statement.. by
Xiamen
I have created this "if" statement.
=IF(G17=(166719),"1", IF(G17=(165852),"2", IF(G17=(165851),"0",
IF(G17=(166718),"1", IF(G17=(166685),"4",...
|
March 25th, 2010 08:23 PM
by Ziggy
|
3 |
135 |
|
|
|
March 25th, 2010 08:13 PM
by Ziggy
|
3 |
113 |
|
|
Combining data by
nitengale
I'm sure there is a formula out there to do this, but I'm not finding any
help in the help function in excel.
I have one worksheet for each day of the month...
|
March 25th, 2010 07:57 PM
by Eduardo
|
1 |
169 |
|
|
|
|
2 |
102 |
|
|
Excel data from spreadsheet to database by
Ricki Miles
Can anyone please direct me to an article that has instructions on how to
gather data from an Excel 2003 spreadsheet into a separate database? Thank...
|
|
1 |
130 |