Search results

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

Yipeee found it!!! => row()*4 -6 :) Super thanks to Hui and Narayan for the formula and all the help. Bye Prashanth

Hi, Thank you so much. But my problem is the formula does not start in the first line as there are some headings etc. In my sheet the first formula is in row 3 which should correspond to the row 6 in the data sheet. row 3 - > row 6 row 4 -> row 10 row 5 -> row 14 row 6-&#62...

Hi Hui, What does the ,(2+ROW()*4) do? Thanks in advance Prashanth

Hi Hui, Appreciate the help. But with the limited knowledge of excel I possess I am not able to decipher the logic in the formula, hence I am not able to use it to my problem. Can you please help me in a more NOOB way. Thanks, Prashanth

Hi Narayan, Yes. Is it very stupid ? :| Thanks Prashanth

:) We are back to the DPR sheet. There is no complicated formula. In Derived Sheet Say R1C1: = 'Scope&Actuals'!S6 Say R2C1: = 'Scope&Actuals'!S10 Say R3C1: = 'Scope&Actuals'!S14 and so on.... The increment is exactly 4. The source sheet will not change. So when I drag down from R1C1...

Hi All, This might be a super stupid question. When I drag down a cell with a formula , the non$ items in the cell increment in the same direction as the reference one row at a time, but when the dragging down needs to refer data which are not one cell down , but instead 4 cells down from...

Hi Narayan and Faseeh, Firstly the support has been amazing !!!! Thanks so much. The sumifs worked beautifully. I had some glitches then later realized the sumifs work only if all the ranges are the same. Named ranges also helped me make the formula look decent. Thank you so much guys.

Hi Narayan, I dont think so, the DPR-Log sheet will be updated everyday.Almost 10-15 lines of entry would be added everyday. So the data would be huge within 3-4 months, so the sumproduct reference has to be able to scale that. Thanks Prashanth

Hi Narayan, Uploaded the cleaner sheet. http://dl.dropbox.com/u/23746991/DPR.xls Thanks, Prashanth