We want a code/formula, who can search the numerical value in cell "E" which we put on cell "D", i mean we will first put the code/formula and after that when we put numerical value it will search the value from next cell and when it will find any one value its stop searching.
same will start from next text/number which put in cell
Excel 2010 32 bit
A B C D E F G 1 It’s my first sheet 2 3 S.No. Year Batch 4Entry 1 9319 3000 5 2 3219 3200 6 3 7819 8000 7 4 2419 4000 8 5 1219 2000 9 6 9319 3000 10 7 6819 8000 11 8 9419 4000 12 9 2419 4000 13 10 8319 3000 14 11 3519 5000 15 12 5619 6000
Sheet: Sheet1
after putting the number/text in column D
Excel 2010 32 bit
A B C D E F G 21 Required sheet 22 S.No. Year Batchonly for your clarity 23Entry 1 9319 3000 24 2 3219 3200 25 3 78193000,3200,8000 8000 26 4 2419 4000 27 5 1219 2000 28 6 93193000,2000,4000 3000 FlagS.no. 3 value find here 3000 29 7 6819 8000 30 8 94194000 4000 FlagS.no. 6 value find here 4000 31 9 24193000,8000,4000 4000 FlagS.no. 8 value find here 4000 32 10 83193000,8000,4000 3000 FlagS.no. 9 value find here 3000 33 11 3519 5000 34 12 5619 6000
Sheet: Sheet1
Bookmarks