Hi Saliha The normal LOOKUP search for the 1st occurrence of the value. This LOOKUP searches for the last occurrence of the value. I don't un...
Hi Saliha See if this helps. Sunny
Hi Saliha The value in cell B42 (23) is different from the others in column B (8). Sunny
Hi Melissa Using the data that Mynda had unpivoted, I created 2 PivotTables. One shows the total count of responses and another the %. I h...
Hi Jason How about a PivotTable solution? I grouped the Dates and then using Max and Min for the Values and some formatting to the entire PT. ...
Hi Daniel I have modified my original formulas. I think it will work for any combination of dosages. I have included 3 examples. Do let us...
I tested that too but without any examples I was unable to determine it's accuracy. You can give it a try and let us know how it worked out.
Hi Daniel Like I had mentioned before, give us examples of your data and the expected results, as many as possible, so that we can see many scenari...
Hi Daniel I have this crazy idea of using VLOOKUP to get close to the factors you wanted. It doesn't work on all figures though Hope it help...
Hi Daniel This is as close as I can get to what you wanted. As for your factors, I don't think it is too much to ask. Many things are possible i...
Hi Daniel You should provide as many scenarios as possible (preferable 10). It is difficult for us to guess your expected results for different ...
Hi Daniel You can try =ROUNDUP($A$2/7,0) You should attach more samples of your expected results (preferably in a workbook) for us to give a ...
Hi Ashley Attached is the updated file. Select S1 then hold the CTRL key and click on the S2 tab to group them. You can now print them at the...
Hi Ashley You will need VBA for that. Please refer attachment. Hope this helps. Sunny
Hi Cody You can try this : =IF([@[Transaction Type]]="Buy","+",IF([@[Transaction Type]]="Sell","-","")) Sunny