worst

Hi I have a financial model which includes a whole heap of scenario analysis. To change the scenario for each cell you click the drop down and select best, base or worst. However, if you wan to run a worst case for everything you have to select each individual cell and select worst. Is there a...

I am trying to do something that should be simple, by my brain is having a dumb block. I have a table of sites showing their ranking for various performance measures. I just want to create a list showing which is their best and worst measures, but I'm getting confused where they may be the same...

Hi I'm trying to put together a list of students with the worst punctuality. I couldn't find a formula so I thought I would try advanced filter. This worked great for values below 90, however, when I try to extract the top 15 with the worst punctuality the filter doesn't seem to happen. The...

Hi, I'm asking for your help, I'll try to explain as detailed as possible what I'm in need of(and couldn't figure out a way to do it yet). So, I have a table that contains a number of products, for each product the yield is introduced each week, I would like to achieve to get the top 4 worst...

Is there an easy way to replace a portion of a string without using left/mid/right functions? The best way to explain is by example. Lets I have in a cell, "Tuesday is the best day of the week," and I want to input into another cell, "Tuesday is the worst day of the week." Is there a simpler...

My sheet 1 (Raw Data) looks like this <colgroup><col><col><col></colgroup><tbody> Experience Height P1 Best Tallest P2 Worst Tallest P3 Worst Tall P4 Good Short P5 Bad Tall P6 Worse Short P7 Best Shorter P8 Bad Shortest P9 Worse Shorter P10 Worst Shortest </tbody> My...