Nested "IF AND THEN" - Need expert guidance please!

kdsill

New Member
Joined
Aug 17, 2012
Messages
1
I am struggling with a formula and have read (and benefitted) from some earlier threads. However, looking for the elegant solution that may not exist...

I'm building a scheduler for a team of 200+ individuals.
I have 50K rows of data with a large number of columns. I'm trying to build a function that will present in a pivot table a limited number of responses. Specifically, the data has client names etc as well as state, city, county, service rep (1-27), criticality aka frequency (1-4), complexity - aka task time (1-4), and last inspection date (updated automatically) and next scheduled inspection date (calculated).

I'm trying to build a formula that will isolate the clients by service rep sorted to show the past due or due now (today) across the criticality. I've tried a nested if and statement, but it isn't working as I envisioned. I can do a good bit of this in pivot filters, but really wanted it to be a more refined list that presents for the current day...

This is way out of my skillset... I'm turning to you experts for help!
 

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.

RaviWildcat

Board Regular
Joined
Jun 18, 2010
Messages
97
I am struggling with a formula and have read (and benefitted) from some earlier threads. However, looking for the elegant solution that may not exist...

I'm building a scheduler for a team of 200+ individuals.
I have 50K rows of data with a large number of columns. I'm trying to build a function that will present in a pivot table a limited number of responses. Specifically, the data has client names etc as well as state, city, county, service rep (1-27), criticality aka frequency (1-4), complexity - aka task time (1-4), and last inspection date (updated automatically) and next scheduled inspection date (calculated).

I'm trying to build a formula that will isolate the clients by service rep sorted to show the past due or due now (today) across the criticality. I've tried a nested if and statement, but it isn't working as I envisioned. I can do a good bit of this in pivot filters, but really wanted it to be a more refined list that presents for the current day...

This is way out of my skillset... I'm turning to you experts for help!


Hi there - if you like you can email me the file and I'lltake look at it tonight?

ravi_a_rao@yahoo.com
 

Watch MrExcel Video

Forum statistics

Threads
1,129,578
Messages
5,637,204
Members
416,960
Latest member
Carbon1198

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top