syedbokhari
Board Regular
- Joined
- Aug 19, 2013
- Messages
- 94
Hey Chaps
I've miss the boards
I am having trouble developing a formula which will return a field (specific cells back to me) based on some conditions.
Basically I want a formula which will return the date (G3-T3) to me on each client. On the conditions of there usage.
So I want it to extract the value of the first number to comes across (the value of the number does not matter).
E.g. Gissle (D5) "The formula should go along and provide me with the date (value) "1/7/2013" [Cell I3) in cell [E5).
It just needs to hit the first value it comes across horizontally and provide me with the date (field) which it is located in Column E (E5-E11).
All help is UBER appreciated as I need this to solve a problem and save at work because I had to manually scope out the first value and insert and copy the date (took an hour).
I hope it is possible
And thanks again Chap!
4 </a>
I've miss the boards
I am having trouble developing a formula which will return a field (specific cells back to me) based on some conditions.
Basically I want a formula which will return the date (G3-T3) to me on each client. On the conditions of there usage.
So I want it to extract the value of the first number to comes across (the value of the number does not matter).
E.g. Gissle (D5) "The formula should go along and provide me with the date (value) "1/7/2013" [Cell I3) in cell [E5).
It just needs to hit the first value it comes across horizontally and provide me with the date (field) which it is located in Column E (E5-E11).
All help is UBER appreciated as I need this to solve a problem and save at work because I had to manually scope out the first value and insert and copy the date (took an hour).
I hope it is possible
And thanks again Chap!
Excel Workbook | |||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | |||
2 | * | * | * | Usage | * | * | * | * | * | * | * | * | * | * | * | * | * | ||
3 | * | Date | * | 1/5/2013 | 1/6/2013 | 1/7/2013 | 1/8/2013 | 1/9/2013 | 1/10/2013 | 1/11/2013 | 1/12/2013 | 1/13/2013 | 1/14/2013 | 1/15/2013 | 1/16/2013 | 1/17/2013 | 1/18/2013 | ||
4 | Client | * | * | * | * | * | * | * | * | * | * | * | * | * | 8 | * | * | ||
5 | Giselle | * | * | * | * | * | * | * | * | * | 5 | * | * | * | * | * | * | ||
6 | Elaine | * | * | * | * | * | * | 4 | * | * | * | * | * | * | * | * | * | ||
7 | Lidi | * | * | 4 | * | * | * | * | * | * | * | * | * | * | * | * | * | ||
8 | Eliza | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | ||
9 | Ji | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | 4 | ||
10 | Erika | * | * | * | * | 1 | * | * | * | * | * | * | * | * | * | * | * | ||
11 | Maria | * | * | * | * | * | * | * | * | 5 | * | * | * | * | * | * | * | ||
12 | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | ||
Sheet1 |
4 </a>
Last edited: