|
|
Vlookup returning a YES or NO by
Rob
Hello
I'd like to return a yes or no response.
at the moment only the YES is working.
Can anyone give me a...
|
|
6 |
94 |
|
|
|
|
3 |
78 |
|
|
|
September 18th, 2008 12:48 AM
by Pete_UK
|
14 |
158 |
|
|
Pulling partial information from a cell by
Emeryville John
Hi,
Thanks to Dave and Peo for help on my previous request.
I have a list of 5 digit zip codes (eg. 90210) and a list of 5 + 4 digit zip
codes (eg....
|
|
2 |
147 |
|
|
|
September 18th, 2008 12:23 AM
by v!v
|
4 |
172 |
|
|
nested subtotal with sumproduct by
SteveDB1
howdee all.
Last month I'd asked about nesting a subtotal function with a sumproduct.
While my initial question was answered (the way I could explain it), I've...
|
September 18th, 2008 12:05 AM
by SteveDB1
|
0 |
120 |
|
|
|
September 18th, 2008 12:04 AM
by T. Valko
|
11 |
390 |
|
|
Need help summing time by
ascottbag-hcm
Can anyone please offer help with summing the following example in excel so
that my result is returned in hours, minutes and seconds? The cell format...
|
|
6 |
196 |
|
|
Mix text and numbers with leading zeros by
Susan B
Good morning,
Trying to create barcodes by putting text (W0410) plus 08, plus a five digit
number beginning with 000001 and incrementing by 1. The leading...
|
September 17th, 2008 11:03 PM
by Susan B
|
3 |
118 |
|
|
Combining functions: Subtraction and IF by
Jeguth1s
I am trying to combine 2 functions. I need the formula to first calculate this:
=C3-K3.
Based on the value returned i need to combine it with the formula...
|
September 17th, 2008 10:58 PM
by T. Valko
|
1 |
121 |
|
|
|
|
3 |
151 |
|
|
|
|
7 |
143 |
|
|
Last Friday of the month by
Alfredo_CPA
I have in cell "A5" the last day of the month (i.e. las month was 08-31-08
and this month will be 09-30-08)
I need a formula in "A6" (that works for every...
|
September 17th, 2008 10:16 PM
by T. Valko
|
9 |
141 |
|
|
Hybrid vlookup - sum function by
Emeryville John
Hi,
I have two tables that each have 2 columns. The first column in the first
table is composed of dates that are in ascending order, but have some...
|
|
2 |
119 |
|
|
Vlookup by
mary/payroll
I have two spread sheets. One has employee benefits 09/12 and the other has
employee benefits 09/19. I want to compare the employee benefits and they
are...
|
|
0 |
93 |
|
|
|
|
5 |
111 |
|
|
|
September 17th, 2008 09:07 PM
by hankach
|
2 |
201 |
|
|
|
September 17th, 2008 08:55 PM
by BKP
|
2 |
129 |
|
|
Linking Workbooks by
crimlaw73
Ok here goes.......I work in Quickbooks for 5 different companies. Every
month I export the company financials from Quickbooks into Excel. Once in
Excel that...
|
|
0 |
135 |
|
|
Complicated Countif application by
mpenkala
Hi there,
I'm in need of some help... here's the problem.
In ColumnA I have a list of numbers (thousands) ranging from 0 to 50.
What I need to do is count...
|
September 17th, 2008 08:29 PM
by mpenkala
|
4 |
130 |