Search results

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 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 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 , Long Question alert !! I need help on speeding up the sumproduct function in my company sheet. This is the scenario. This is basically for a Daily Progress Report for a construction site.(dpr) 1. I have set up the collection sheet where all engineers would enter that day's...

Hi, Is it possible to consolidate text data like we consolidate numerical data in pivot table. Example :- COl A COL B ABC A CDE B FGH C XYZ A Is it possible to summarize all corresponding data to 'A'. Not by using Sort but into a separate sheet which is...