|
|
V Lookup by
Lin4it
Why when using a V Lookup do I get the result from the row above that required?
=VLOOKUP("Greater London",range1,2,0)
The answer should be 29 but I am...
|
|
1 |
91 |
|
|
INDEX / MATCH HELP by
challenged
Hi
Maybe I'm going about this the wrong way but am trying to get results from a
competition showing name place and score (top 3 only) onto a seperate...
|
February 18th, 2010 01:49 PM
by Eduardo
|
1 |
91 |
|
|
Smaller than 0 to return a 0 result by
MWRhino
Every tenant gets one free go per week. I need to create a formula where
where any negative numbers are returned as a '0' result....
|
|
1 |
84 |
|
|
|
|
5 |
125 |
|
|
Prevent Cut and Paste by
BadBoy
Hello,
I have designed a workbook containing many drop windows.
Other people use this book. It contains 31 sheets (one for each day of the
month).
The...
|
February 18th, 2010 12:12 PM
by BadBoy
|
3 |
112 |
|
|
Multiple criteria search by
BeSmart
Hi All
How do I include Four criteria cells to determine the row and one criteria
cell to determine the COLUMN to find a specific cell value? e.g
Sheet One...
|
February 18th, 2010 11:33 AM
by BeSmart
|
2 |
103 |
|
|
sort and select based on criteria by
Iriemon
I have a spreadsheet with the following data, what I would like to do is:
1. sort this in descending order by number of sales (got the macro doing this)
2....
|
|
1 |
126 |
|
|
Copy tab name to a cell or opposite by
RG
What is the the index of the name of the tab? Who can I get the tab name
autmatic to a cell or the other way around? It will be nice to type a name
once - no...
|
|
1 |
107 |
|
|
Selecting different cells each month by
Solomon
Hi MS Office Help,
I would like to know how to choose a selection of cells based on what month
it is in the real world.
For instance, if the...
|
February 18th, 2010 09:36 AM
by Solomon
|
2 |
112 |
|
|
wildcards in sumproduct functions by
K1
I would prefer to use a wildcard for text criteria in sumproduct counting and
adding equations. I have tried versions of "*ABC*" and get false values.
|
February 18th, 2010 09:33 AM
by Pete_UK
|
9 |
143 |
|
|
|
February 18th, 2010 04:47 AM
by Huseyin
|
0 |
103 |
|
|
Combo boxes and AutoSum by
sc
What function would I use to add a range of numbers that includes a combo
box? I tried AutoSum but the Total doesn't recalculate when I change the
number in...
|
February 18th, 2010 04:35 AM
by T. Valko
|
1 |
127 |
|
|
Adding formula by
Scoober
I am trying to complete a formula that will enable me to do the following.
D4 = C3 + C4
D5 = C4 + C5
So the total in the D columnis the addition of the new C...
|
February 18th, 2010 03:32 AM
by T. Valko
|
1 |
104 |
|
|
Cell content capture and release by
CellShocked
Hey guys.
I want to make a sheet that has a cell in it where I use a barcode
scanner to grab a barcode.
What I want is for the cell to grab the barcode,...
|
|
0 |
104 |
|
|
IFAND then SUM by
Seree
I'm trying to come up with a formula to check if this is true in column A AND
that is true in column B then SUM column C for corresponding rows.
Here's part...
|
February 18th, 2010 02:21 AM
by Pete_UK
|
1 |
89 |
|
|
|
February 18th, 2010 02:15 AM
by Pete_UK
|
1 |
140 |
|
|
Multiple data validation criteria? by
ker_01
Working in 2003, but this workbook has to also work in 2007
For this project I have to avoid macros because users are remote and may not
enable macros.
I...
|
February 18th, 2010 12:33 AM
by ker_01
|
0 |
104 |
|
|
Second cell in Data Validation by
WFariss
Can Data Validation return a value to a second cell from an adjacent column
in the list as well as the first cell when validation criteria is set as list?
--...
|
|
3 |
133 |
|
|
Function for multiple tabs in one worksheet by
Excel makes life easier
I have a standard template for all tabs in one workbook (there are about 100
different tabs). What is the function to sum the same cells in each tab and...
|
|
2 |
123 |
|
|
Check for case of string by
msnyc07
So as I work with this VBA from coder I see you can set case of string
Is there anyway to examine case? Either If All Uppercase or if Mixed/Init
Caps is fine...
|
February 18th, 2010 12:11 AM
by Mike H
|
3 |
77 |