Quote:
Originally Posted by excelledsoftware
That is the most complicated formula I have ever seen. Could you attach a sample of your worksheet so we can try to help you with a more conventional solution.
|
RL ROCKGROUP GRADEGROUP Volume BCM 145.00 GKSAP WASTE - 145.00 GKSAP MO - 145.00 GKSAP LG - 145.00 GKSAP MG - 145.00 GKSAP HG - 145.00 145.00 GKTR WASTE - 145.00 GKTR MO - 145.00 GKTR LG - 145.00 GKTR MG - 145.00 GKTR HG - 145.00 145.00 GKFR WASTE - 145.00 GKFR MO - 145.00 GKFR LG - 145.00 GKFR MG - 145.00 GKFR HG - 145.00 145.00 FWSAP WASTE - 145.00 FWSAP MO - 145.00 FWSAP LG - 145.00 FWSAP MG - 145.00 FWSAP HG - 145.00 145.00 FWTR WASTE - 145.00 FWTR MO - 145.00 FWTR LG - 145.00 FWTR MG - 145.00 FWTR HG - 145.00 145.00 FWFR WASTE - 145.00 FWFR MO - 145.00 FWFR LG - 145.00 FWFR MG - 145.00 FWFR HG - 145.00 145.00 HWSAP WASTE - 145.00 HWSAP MO - 145.00 HWSAP LG - 145.00 HWSAP MG - 145.00 HWSAP HG - 145.00 145.00 HWTR WASTE - 145.00 HWTR MO - 145.00 HWTR LG - 145.00 HWTR MG - 145.00 HWTR HG - 145.00 145.00 HWFR WASTE - 145.00 HWFR MO - 145.00 HWFR LG - 145.00 HWFR MG - 145.00 HWFR HG - 145.00 145.00 SOFTWAST WASTE - 145.00 145.00 TRNSWAST WASTE - 145.00 145.00 HARDWAST WASTE 9.01 145.00 142.50 GKSAP WASTE - 142.50 GKSAP MO 0.42 142.50 GKSAP LG - 142.50 GKSAP MG - 142.50 GKSAP HG - 142.50 142.50 GKTR WASTE - 142.50 GKTR MO - 142.50 GKTR LG - 142.50 GKTR MG - 142.50 GKTR HG - 142.50 142.50 GKFR WASTE - 142.50 GKFR MO - 142.50 GKFR LG - 142.50 GKFR MG - 142.50 GKFR HG - 142.50 142.50 FWSAP WASTE - 142.50 FWSAP MO - 142.50 FWSAP LG - 142.50 FWSAP MG - 142.50 FWSAP HG - 142.50 142.50 FWTR WASTE - 142.50 FWTR MO - 142.50 FWTR LG - 142.50 FWTR MG - 142.50 FWTR HG - 142.50 142.50 FWFR WASTE - 142.50 FWFR MO - 142.50 FWFR LG - 142.50 FWFR MG - 142.50 FWFR HG - 142.50 142.50 HWSAP WASTE - 142.50 HWSAP MO - 142.50 HWSAP LG - 142.50 HWSAP MG - 142.50 HWSAP HG - 142.50 142.50 HWTR WASTE - 142.50 HWTR MO - 142.50 HWTR LG - 142.50 HWTR MG - 142.50 HWTR HG - 142.50 142.50 HWFR WASTE - 142.50 HWFR MO - 142.50 HWFR LG - 142.50 HWFR MG - 142.50 HWFR HG - 142.50 142.50 SOFTWAST WASTE 288.95 142.50 142.50 TRNSWAST WASTE - 142.50 142.50 HARDWAST WASTE 5,975.62 142.50 140.00 GKSAP WASTE - 140.00 GKSAP MO - 140.00 GKSAP LG - 140.00 GKSAP MG - 140.00 GKSAP HG - 140.00 140.00 GKTR WASTE - 140.00 GKTR MO - 140.00 GKTR LG - 140.00 GKTR MG - 140.00 GKTR HG - 140.00 140.00 GKFR WASTE - 140.00 GKFR MO - 140.00 GKFR LG - 140.00 GKFR MG - 140.00 GKFR HG - 140.00 140.00 FWSAP WASTE - 140.00 FWSAP MO - 140.00 FWSAP LG - 140.00 FWSAP MG - 140.00 FWSAP HG - 140.00 140.00 FWTR WASTE - 140.00 FWTR MO - 140.00 FWTR LG - 140.00 FWTR MG - 140.00 FWTR HG - 140.00 140.00 FWFR WASTE - 140.00 FWFR MO - 140.00 FWFR LG - 140.00 FWFR MG - 140.00 FWFR HG - 140.00 140.00 HWSAP WASTE - 140.00 HWSAP MO - 140.00 HWSAP LG - 140.00 HWSAP MG - 140.00 HWSAP HG - 140.00 140.00 HWTR WASTE - 140.00 HWTR MO - 140.00 HWTR LG - 140.00 HWTR MG - 140.00 HWTR HG - 140.00 140.00 HWFR WASTE - 140.00 HWFR MO - 140.00 HWFR LG - 140.00 HWFR MG - 140.00 HWFR HG - 140.00 140.00 SOFTWAST WASTE - 140.00 140.00 TRNSWAST WASTE - 140.00 140.00 HARDWAST WASTE 2,206.97 140.00
i arrange it in this format:
RL GKSAP GKSAP GKSAP GKSAP GKTR GKTR GKTR GKTR GKTR GKFR
WASTE LG MG HG WASTE MO LG MG HG WASTE 145.00 - - - - - - - - - - 142.50 - - - - - - - - - - 140.00 - - - - - - - - - - 137.50 - - - - - - - - - - 135.00 - - - - - - - - - - 132.50 - - - - - - - - - - 130.00 - - - - - - - - - - 127.50 - - - - - - - - - - 125.00 - - - - - - - - - - 122.50 - - - - - - - - - - 120.00 - - - - - - - - - -