Search results

Dear Deb, Thanks for your kind support. The formula is working perfectly as per my requirement. Great……….Thank you once again …..

Dear Deb, its looking correct but i am unable to copy the same in my original sheet. Plz help.

Dear Deb, This formula is not working at all. ctrl+shift+enter returns blank and only enter returns 1/0/1900 0:00 Again i am trying to let you understand my issue. I want to find out the date and time (from column G) matching with column C but the value (Date and time) of Column G should...

Dear Deb, below formula is sutaible for my data. =INDEX($G$3:$G$27,MATCH(MIN(IF($F$3:$F$27=C3,ABS($G$3:$G$27-A3))),IF($F$3:$F$27=C3,ABS($G$3:$G$27-A3)),0)) Plz note the above formula is returning the closest value. Plz rectify so that it returns only lower closest value. it is also...

I have a set of data like below. Now I want to set conditional formatting like, If A1=AA then C,E,F column will return N/A filled with red color otherwise blank. I want to avoid formula in cell. A...B……….C……..…D……..…E………....F 1 AA…………….N/A……………....…N/A……..N/A 2 3

Thanks HUI. 2nd solution is much better in my case.

How to add a prefix in particular cell. Suppose if I put 11022103 it will automatically return 2211022103. Here I add 22 with my putting value. 22 will be same for entire column.

Dear Debraj, previous formula was great only remove the upper value (with N/A) if doesn't find lower value. one more thing it is accepting closest value not closest lower value. Plz check once again. latest formula is not working properly.

Dear Debraj, One more help is require on the same. Need to debug. If Column D finds the lower value or not available (matching with Column C and column A) then formula works correctly but if he is not able to find lower value then its returning upper value. I want only lower value, if he...

Dear Debraj, Great............ Real hero in excel.... Thanks a lot.

dear Debraj, I have downloaded your file. Go through the same and found some discrepancies. I am trying to let you understand my quarries. I want to find out the date and time (from column G) matching with column C but the value (Date and time) of Column G should be closet lesser value...

Dear Debraj, if a click on D19, cells are highlighting D19, D23,F8, F27. now i want to return the value which is lesser closest to A19. A19 = 2/4/2013 11:14:39 AM then closest lesser value from 'F8:F27' will be 2/3/2013 9:33:00 PM similarly when i click D26, cells are highlighting...

Dear Debraj, I have go through your workbook and the data for below cell no is not coming exactly. Plz check the same. Cell No.......Data comes...................Data Should Comes D19...........2/1/2013 0:40................2/3/2013 21:33 D26...........#NUM!........................2/3/2013...

Dear Debraj, it works. but few cell its returning wrong value. if you go through my workbook, D19 is showing wrong value and D26 is returning #NUM!. requesting you to plz check on the same.

suresh ji.. plz help

hi nipendra if you download my workbook, I want to return the value in column D (vlookup with column C, return the value from column G but keep in mind that the value should be closest lower value of column A)

can someone help me to get the formula

sir.. plz find the download link https://hotfile.com/dl/195951480/50746e6/Table.xlsx.html

suresh ji... can u plz help on this

upload the workbook at http://hotfile.com (filename: table)

hi, unable to upload the workbook, can u plz help on the same. should i need to download and install the dropbox

I have two separate tables like below where unique ID may be duplicate. Now I want to set a formula in return Value column of Table 1 where the value will be Time A of Table 2 and the same should be the closest lesser value of Time A of Table 1 Table...