|
|
cursor movement wrong by
fireplacetim
My tab key in Excel moves the cursor a whole page to the right. Pressing
enter moves the cursorone space right. HGow do I change the movements to a
normal...
|
|
2 |
114 |
|
|
Supplier list by
talalhisham
what formula do i use to find new suppliers in a big list?
I have a spreadsheet with suppliers and qty of goods received for each of
them. I have formula in...
|
May 14th, 2009 05:34 PM
by CLR
|
2 |
130 |
|
|
|
May 14th, 2009 05:29 PM
by CLR
|
1 |
84 |
|
|
SUMIF or SUMPRODUCT? by
EricB
The following formula is returning a ‘0’ outcome:
=SUMPRODUCT(--('TB SAICMB'!B2:B1000="'Computer Sales"),--('TB SAICMB'!D2:D1000="Admin"),--('TB...
|
|
9 |
153 |
|
|
Use cell to determine column in formula by
JeffC
Hi, I have a worksheet in which I add a new column each month for the new
activity in the trial balance. that information is in one sheet. In
separate...
|
|
2 |
97 |
|
|
|
|
5 |
98 |
|
|
Assigning a Worksheet Name to a Cell by
bcw_now
Example, I want to add a new monthly data worksheet to by workbook and pull
all the present and past monthly data for a specific client. Currently the
data...
|
|
3 |
78 |
|
|
|
|
5 |
93 |
|
|
Conditional Formatting by
gjuarez
Using Conditional formating Icons (Arrows)
Cell 1 has a YTD formula, Cell 2 through 4 has Numerical Data
Using the default formula of:
Up Arrow = 67%
Side...
|
|
1 |
73 |
|
|
Birthdate 01/01/2000 Remove Slashes by
Sprowler
We are trying to remove the slashes in the birthdate field but keep the
leading zero. We have used text to columns to separate the fields, then
converted...
|
|
3 |
109 |
|
|
Excel: Last non zero value in a row by
SimmoG
I need to (in formula not VB code) lookup the last non zero value in a row
and return the "header record value" for that column
e.g below - I want to see...
|
|
2 |
125 |
|
|
Count Number of Rows by
Hoffma
I filtered non-numerical data in a spreadsheet and need to count the number
of remaining rows. The row numbers are not in order due to filtering. What
is...
|
|
2 |
84 |
|
|
SumIf statement: incrementing by
Kesbutler
I have the following formula:
=SUMIF('weekly dates'!A1:AZ1,""&A5,Details!L7:BK7)
Weekly dates is a static sheet, &A5 is the current date and Details!L7:BK7...
|
|
2 |
148 |
|
|
|
|
2 |
113 |
|
|
Sort two tables of data by
AMH
I am not sure if this has been asked/answered before but I couldn’t find
anything that would help me, so please if you have any ideas they would be...
|
May 14th, 2009 01:51 PM
by joel
|
5 |
102 |
|
|
Separate names into columns by
Carter
I have a column that has first and last name or it may have first, middle and
last name. I need to know how to pull the first name in a separate column
and...
|
May 14th, 2009 01:46 PM
by Carter
|
3 |
94 |
|
|
|
|
4 |
80 |
|
|
|
May 14th, 2009 12:05 PM
by MCFD
|
2 |
111 |
|
|
Using the information from a pivot table by
Louja
Hi there,
I was wondering if anyone would be kind enough to help.
I have a report that I receive daily and need to total month to date
lots by 2 fields...
|
May 14th, 2009 11:57 AM
by Lori
|
3 |
97 |
|
|
|
|
8 |
97 |