Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
INDENTIFY COLUMN
i WOULD LIKE TO ABLE TO INDENTIFY COLUMN THAT A DATE IS IN
I.E IF DATE IS IN EG B17 THEN I NEED A FORMUAL SAY IN A1 THAT WILL IDENTIFY AND ENTER B IN THE COLUMN. THANKS sTUART |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
INDENTIFY COLUMN
hAVE YOU LOST YOUR caps LOCK KEY?
"Stuart WJG" wrote in message ... i WOULD LIKE TO ABLE TO INDENTIFY COLUMN THAT A DATE IS IN I.E IF DATE IS IN EG B17 THEN I NEED A FORMUAL SAY IN A1 THAT WILL IDENTIFY AND ENTER B IN THE COLUMN. THANKS sTUART |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
INDENTIFY COLUMN
Hi
perhaps not made myself clear. I need a formula that can look for a date in a cell that matchs a date in a range and then enter column letter in the formula cell Formula in A1 Variable cell (date) A2 Range B1:ah6 Hope this clarifys Stuart "Gaurav" wrote: hAVE YOU LOST YOUR caps LOCK KEY? "Stuart WJG" wrote in message ... i WOULD LIKE TO ABLE TO INDENTIFY COLUMN THAT A DATE IS IN I.E IF DATE IS IN EG B17 THEN I NEED A FORMUAL SAY IN A1 THAT WILL IDENTIFY AND ENTER B IN THE COLUMN. THANKS sTUART |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Indentify Shift number in 24 hour period | Excel Worksheet Functions | |||
Referencing date column A & time column B to get info from column | Excel Discussion (Misc queries) | |||
Based on a condition in one column, search for a year in another column, and display data from another column in the same row look | Excel Discussion (Misc queries) | |||
Indentify value from multiple values in a single cell | Excel Worksheet Functions | |||
How to indentify duplicates in a "Self Populating" field? | Excel Discussion (Misc queries) |