Search results

Hey Faseeh, That was an excellent suggestion, I could pinpoint my error that way and now it is working perfectly! Thanks a ton for your help! Best regards AJ

I have been using one IFMATCH formula to generate a report since a month with complete success, but suddenly it has stopped working. I am completely puzzled as nothing has changed between the last report and this one I am trying to generate now. There are two separate worksheets in two...

Hi Kaushik, Please let me know if you could get the files. I have tried with IFMATCH and it did work, but after certain rows it is giving a crazy date as output 1/0/1900 I am using =IFERROR(INDEX(Old!G2:G2,MATCH(A2&"^^"&E2&"^^"&F2&"^^"&H2,Old!AG2:AG2,0)),"") Thank you for your help! AJ

Hi Kaushik, Thank you very much for your prompt response and your help. Perhaps you could not access the files because without your e-mail skydrive does not give access to the files. But now I have sent the shared links to your e-mail pharmacyjukaushik[at]yahoo[dot]com, I am sure you will be...

Hi Kaushik, Thank you very much for your help. I have uploaded the samples with names Old Report and New Report in skydrive.live.com The link is https://skydrive.live.com/?cid=15E94FDF4E576944#cid=15E94FDF4E576944 In case you cannot access this, I will need your e-mail to send you the...

There are two separate reports as two separate Excel file. The old one is on a server and the new one is pulled once each week from a system where data is updated all the time. Column G is added to the new report as a Insert Column function. However, 100s of new rows are added each week. So...

Hi Narayan, Thanks again for your help. I thought I answered all your questions, sorry about missing out the last one. As I said in my last response, if A2431 contains UKA1 in the reference report, G2431 contains contains No and hence the formula populates the G column at G130 with No in the...

Hi Narayan, Thanks again for your prompt response! Column G is populated either with Yes or No. To answer your second question, if the cells 131 till the end of the report are formatted General or Text, the result is that the value shown in 0, where as if the same cells are formatted Number...

Hi Narayan, Just forgot to add that the format of all cells in column G is actually the very same, from G2 till G6378 it is format Custom - [$-10409]m/d/yyyy

Hi Narayan, Thank you for your prompt response. Changing the format to Text or General makes it the number 0, and changing the format to Number makes it 0.00 Sorry about that date, it is not 31/0/1900 but just 1/0/1900. These reports exceed 6200 rows and each week, the number of rows goes...

Hi, If you know any way to resolve this, PLEASE send in your suggestions: I am using a VLOOKUP formula to populate the G Column with Yes or No in a new Excel 2010 Report. The number of rows change every week and each week a new report is prepared by comparing with the last week's report. The...