Recent content by pr4peace

Hi Sajan and Luke, Did not even understand a little bit of both the formulas, hence could not adapt it to my problem :| :( I will need a forensic on that formula and unless you are ok with time constraints, you dont need to explain it anytime now!! I am going with a slower sheet :)...

Hi All, Firstly sorry for the delayed response, got stuck with work. Secondly a huge thanks for all the wonderful replies . @narayank: thanks for the formula, was a little complicated to understand but got it to work. @luke: that formula is so simple and awesome, I felt stupid not to...

Hi Luke, Any suggestions? Thanks, Prashanth

Hi Luke M, :( Understood your use case. Thats a showstopper!!! And I am not able to wrap around the solution. Help. Just to dissect the solution. Since all the match functions are returning the row numbers. The result is just to see how many of these numbers match . Isnt it? I.E if...

Super dumb error, I had disabled macros !!!!! :( But the UDF still had some problems. It was not returning the right answer when I drag down further I did some tinkering to your formula and got it working , but I still dont know the use case where it will fail. Function MatchCount(Crit1...

Hi Luke M, Thank you so much for your time. I understood the function but I am not able to execute it. I am getting a #NAME error on the formula when I type it in the excel sheet. Sorry for being a noob but I must be missing something fundamental for it to work. PFA...

Hi, A example of what I am doing is attached. Basically we are setting up a labour management system to make insurances for them. We dont want to make two insurances for the same person. So a centralized database is being created , but the file should warn when we are entering a duplicate...

Hi Sir JB7, My bad and my sincere apologies. Thanks, Prashanth

Hi Luke M, Having a very similar problem as above mentioned by mwmo_user. Only that I need the result to be customized as per the nos of criterion being duplicate. A example of what I am doing is attached. Basically we are setting up a labour management system to make insurances for them. We...

Hi Luke M, Supercool. I did exactly as the formula said and it worked like a charm :) Thank you soo much. Bye Prashanth

Hi SirJBy, Thanks for your suggestion, but i still need to make a sort everytime for a new date and a different material. Since I have many materials , I need a single summary sheet which changes based on One value i.e todays(or any other)date. Luke M, Thanks a lot for your immediate...

Hi Luke, Thanks for the suggestion. Pivot Table is an option, but I need to to make it a customized A3 sized report, meaning it contains a whole lot of other materials which also have their own report template. I dont like Pivot table since it has its own mind : . Formulas feel better and...

Hi All, I am in the process of preparing daily , weekly and monthly reports. To prepare number heavy reports I used a lot of help from these forums to guide me on the same. I have a similar problem now , only that now it is a text heavy report. I need help on how to return on say the 2nd or...

Hi All, I have two sheets 1. To capture data in a date wise format - daily production values of Blocks 2. Required Production Schedule month wise for the next 1 year to meed demand Now, I need to prepare a chart which maps my production values to my schedule value month on month. This...

Hi SirJB7, Thanks for the insight , will use this logic when I have to go the other way :) Bye Prashanth