Vishaal
Well-known Member
- Joined
- Mar 16, 2019
- Messages
- 533
- Office Version
- 2010
- 2007
- Platform
- Windows
- Web
Hi All,
We have used a formula in column G, but when we check the Cell Format of any E5:F16 its coming
but when we check the cell format of G5:G16 it is coming the following
Problem is how can we get the Cell Format setting as per first image in column G
please find the excel file also.
We have used a formula in column G, but when we check the Cell Format of any E5:F16 its coming
but when we check the cell format of G5:G16 it is coming the following
Problem is how can we get the Cell Format setting as per first image in column G
please find the excel file also.
xlsx file as u have told.xlsx | |||||
---|---|---|---|---|---|
E | F | G | |||
4 | Amount | Batch | Testing | ||
5 | 3000 | ||||
6 | 3200 | ||||
7 | 3000,3200,8500 | 8500 | |||
8 | 4000 | ||||
9 | 2000 | ||||
10 | 4000,2000,3000 | 3000 | Flag | ||
11 | 7654 | ||||
12 | 3000,8000,4000 | 4000 | Flag | ||
13 | 6000 | ||||
14 | 4000,6000,3000 | 3000 | Flag | ||
15 | 5000 | ||||
16 | 6000 | Flag | |||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
G5:G16 | G5 | =IF(COUNTIF($G$4:G4,LOOKUP(2,1/SEARCH(F5,$E$4:E4),ROW($E$4:E4)))>0,0,IFERROR(LOOKUP(2,1/SEARCH(F5,$E$4:E4),ROW($E$4:E4)),"")) |