LinkBack URL
About LinkBacks
aslam5420 
Hi,
I have data in column A
Hi,
I have data in column A
Last edited by aslam5420; 07-10-2022 at 09:59 AM.
Cell I3 formula , Drag down
Formula:
=INDEX(F:F,MATCH(TEXT(H3,"H:MM"),TEXT(A:A,"H:MM"),))
Hi Sir wk9128,
Thank you this formula worked for me.
But i am noticing a little issue. When i dragged the formula up to four cells from I3 to I7, My File just got hanged for up to 10 seconds. I have to use this formula for file where there are 5000+ rows. So, it would create a lot difficulty. Can you please create a formula with less load on PC.
In I3 try:
Formula:=XLOOKUP(ROUND(H3,16),A:A,F:F,0,0)
<----- If you are happy with your solution please click on the "* Add Reputation" as a way to say thank you.
Hi dosydos,
Thank you so much for this formula. It worked very smoothly with not too much load on my PC.
Really thankful to you
@aslam5420 You're Welcome. Glad to help . Thank You for the feedback
Yes, you can narrow it down
Formula:=INDEX(F$3:F$6000,MATCH(TEXT(H3,"H:MM"),TEXT(A$3:A$6000,"H:MM"),))
Hi Sir wk9128
Thank you so much for this, It now worked fine
@aslam5420 You're Welcome. Glad to help . Thank You for the feedback and rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks