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 |
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 |
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 |
All times are GMT +1. The time now is 10:07 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com