Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula To Show Which Cell Has The Highest Rate
I work for a retail company and am trying to get the formula to show which
location has the highest rate. For instance - Brandon has 25 sales, Tampa has 30, and Clearwater has 50. This formula would automatically determine which store has the highest and show up in RED saying BIGDOG! Any help is better than what I have lol! Thanks! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula To Show Which Cell Has The Highest Rate
Not knowing how many regions you want, I base my answer on three. Let's say
these are in A1:B3. In C1, enter =IF(B1=MAX($B$1:$B$3),"BIGDOG","") Now, conditionally format range C1:C3, cell value equal to BIGDOG, format font as Red -- HTH Kassie Replace xxx with hotmail "it''sh hardy" wrote: I work for a retail company and am trying to get the formula to show which location has the highest rate. For instance - Brandon has 25 sales, Tampa has 30, and Clearwater has 50. This formula would automatically determine which store has the highest and show up in RED saying BIGDOG! Any help is better than what I have lol! Thanks! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula To Show Which Cell Has The Highest Rate
Kassie -
I tried this and it didn't work =( here's what cells I'm using and I want the cell with the HIGHEST amount of sales to say bigdog F4 through F10 Thanks, Mike "Kassie" wrote: Not knowing how many regions you want, I base my answer on three. Let's say these are in A1:B3. In C1, enter =IF(B1=MAX($B$1:$B$3),"BIGDOG","") Now, conditionally format range C1:C3, cell value equal to BIGDOG, format font as Red -- HTH Kassie Replace xxx with hotmail "it''sh hardy" wrote: I work for a retail company and am trying to get the formula to show which location has the highest rate. For instance - Brandon has 25 sales, Tampa has 30, and Clearwater has 50. This formula would automatically determine which store has the highest and show up in RED saying BIGDOG! Any help is better than what I have lol! Thanks! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula To Show Which Cell Has The Highest Rate
I must apologise! Ileft out the bit about copying the formula down!
=IF(F4=MAX($F$4:$F$10),"BIGDOG","") in G4. Now copy down to G10, then do the CF thing -- HTH Kassie Replace xxx with hotmail "it''''''''sh hardy" wrote: Kassie - I tried this and it didn't work =( here's what cells I'm using and I want the cell with the HIGHEST amount of sales to say bigdog F4 through F10 Thanks, Mike "Kassie" wrote: Not knowing how many regions you want, I base my answer on three. Let's say these are in A1:B3. In C1, enter =IF(B1=MAX($B$1:$B$3),"BIGDOG","") Now, conditionally format range C1:C3, cell value equal to BIGDOG, format font as Red -- HTH Kassie Replace xxx with hotmail "it''sh hardy" wrote: I work for a retail company and am trying to get the formula to show which location has the highest rate. For instance - Brandon has 25 sales, Tampa has 30, and Clearwater has 50. This formula would automatically determine which store has the highest and show up in RED saying BIGDOG! Any help is better than what I have lol! Thanks! |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula To Show Which Cell Has The Highest Rate
Ok that worked!!! thank you!!! But when I do the CF it doesn't show up red,
and the number thats largest doesn't either? I'm sorry I'm such a pain! lol... Also, do you know how to have a particular cell reference back to a spreadsheet saved to a website? Thanks "Kassie" wrote: I must apologise! Ileft out the bit about copying the formula down! =IF(F4=MAX($F$4:$F$10),"BIGDOG","") in G4. Now copy down to G10, then do the CF thing -- HTH Kassie Replace xxx with hotmail "it''''''''sh hardy" wrote: Kassie - I tried this and it didn't work =( here's what cells I'm using and I want the cell with the HIGHEST amount of sales to say bigdog F4 through F10 Thanks, Mike "Kassie" wrote: Not knowing how many regions you want, I base my answer on three. Let's say these are in A1:B3. In C1, enter =IF(B1=MAX($B$1:$B$3),"BIGDOG","") Now, conditionally format range C1:C3, cell value equal to BIGDOG, format font as Red -- HTH Kassie Replace xxx with hotmail "it''sh hardy" wrote: I work for a retail company and am trying to get the formula to show which location has the highest rate. For instance - Brandon has 25 sales, Tampa has 30, and Clearwater has 50. This formula would automatically determine which store has the highest and show up in RED saying BIGDOG! Any help is better than what I have lol! Thanks! |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula To Show Which Cell Has The Highest Rate
Which version of Excel do you use?
-- HTH Kassie Replace xxx with hotmail "it''''''''sh hardy" wrote: Ok that worked!!! thank you!!! But when I do the CF it doesn't show up red, and the number thats largest doesn't either? I'm sorry I'm such a pain! lol... Also, do you know how to have a particular cell reference back to a spreadsheet saved to a website? Thanks "Kassie" wrote: I must apologise! Ileft out the bit about copying the formula down! =IF(F4=MAX($F$4:$F$10),"BIGDOG","") in G4. Now copy down to G10, then do the CF thing -- HTH Kassie Replace xxx with hotmail "it''''''''sh hardy" wrote: Kassie - I tried this and it didn't work =( here's what cells I'm using and I want the cell with the HIGHEST amount of sales to say bigdog F4 through F10 Thanks, Mike "Kassie" wrote: Not knowing how many regions you want, I base my answer on three. Let's say these are in A1:B3. In C1, enter =IF(B1=MAX($B$1:$B$3),"BIGDOG","") Now, conditionally format range C1:C3, cell value equal to BIGDOG, format font as Red -- HTH Kassie Replace xxx with hotmail "it''sh hardy" wrote: I work for a retail company and am trying to get the formula to show which location has the highest rate. For instance - Brandon has 25 sales, Tampa has 30, and Clearwater has 50. This formula would automatically determine which store has the highest and show up in RED saying BIGDOG! Any help is better than what I have lol! Thanks! |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula To Show Which Cell Has The Highest Rate
2007... Sorry for delay!
"Kassie" wrote: Which version of Excel do you use? -- HTH Kassie Replace xxx with hotmail "it''''''''sh hardy" wrote: Ok that worked!!! thank you!!! But when I do the CF it doesn't show up red, and the number thats largest doesn't either? I'm sorry I'm such a pain! lol... Also, do you know how to have a particular cell reference back to a spreadsheet saved to a website? Thanks "Kassie" wrote: I must apologise! Ileft out the bit about copying the formula down! =IF(F4=MAX($F$4:$F$10),"BIGDOG","") in G4. Now copy down to G10, then do the CF thing -- HTH Kassie Replace xxx with hotmail "it''''''''sh hardy" wrote: Kassie - I tried this and it didn't work =( here's what cells I'm using and I want the cell with the HIGHEST amount of sales to say bigdog F4 through F10 Thanks, Mike "Kassie" wrote: Not knowing how many regions you want, I base my answer on three. Let's say these are in A1:B3. In C1, enter =IF(B1=MAX($B$1:$B$3),"BIGDOG","") Now, conditionally format range C1:C3, cell value equal to BIGDOG, format font as Red -- HTH Kassie Replace xxx with hotmail "it''sh hardy" wrote: I work for a retail company and am trying to get the formula to show which location has the highest rate. For instance - Brandon has 25 sales, Tampa has 30, and Clearwater has 50. This formula would automatically determine which store has the highest and show up in RED saying BIGDOG! Any help is better than what I have lol! Thanks! |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula To Show Which Cell Has The Highest Rate
On your Home tab, just right of centre, click on Conditional Formatting, then
on Highlight Cells Rules, Text that Contains. Enter BIGDOG! in the inputbox. Click on the down arrow next to "with", and select Red Text. -- HTH Kassie Replace xxx with hotmail "it''''''''sh hardy" wrote: 2007... Sorry for delay! "Kassie" wrote: Which version of Excel do you use? -- HTH Kassie Replace xxx with hotmail "it''''''''sh hardy" wrote: Ok that worked!!! thank you!!! But when I do the CF it doesn't show up red, and the number thats largest doesn't either? I'm sorry I'm such a pain! lol... Also, do you know how to have a particular cell reference back to a spreadsheet saved to a website? Thanks "Kassie" wrote: I must apologise! Ileft out the bit about copying the formula down! =IF(F4=MAX($F$4:$F$10),"BIGDOG","") in G4. Now copy down to G10, then do the CF thing -- HTH Kassie Replace xxx with hotmail "it''''''''sh hardy" wrote: Kassie - I tried this and it didn't work =( here's what cells I'm using and I want the cell with the HIGHEST amount of sales to say bigdog F4 through F10 Thanks, Mike "Kassie" wrote: Not knowing how many regions you want, I base my answer on three. Let's say these are in A1:B3. In C1, enter =IF(B1=MAX($B$1:$B$3),"BIGDOG","") Now, conditionally format range C1:C3, cell value equal to BIGDOG, format font as Red -- HTH Kassie Replace xxx with hotmail "it''sh hardy" wrote: I work for a retail company and am trying to get the formula to show which location has the highest rate. For instance - Brandon has 25 sales, Tampa has 30, and Clearwater has 50. This formula would automatically determine which store has the highest and show up in RED saying BIGDOG! Any help is better than what I have lol! Thanks! |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula To Show Which Cell Has The Highest Rate
Thanks Kassie - Also, I'm tring to format the cells to do the big dog thing
still and i can only get so many cells? I'm using F3-F9, G3-G9,H3-H9, and I3-I9 i get through the first two, then 3 cells into H it stops working? "Kassie" wrote: On your Home tab, just right of centre, click on Conditional Formatting, then on Highlight Cells Rules, Text that Contains. Enter BIGDOG! in the inputbox. Click on the down arrow next to "with", and select Red Text. -- HTH Kassie Replace xxx with hotmail "it''''''''sh hardy" wrote: 2007... Sorry for delay! "Kassie" wrote: Which version of Excel do you use? -- HTH Kassie Replace xxx with hotmail "it''''''''sh hardy" wrote: Ok that worked!!! thank you!!! But when I do the CF it doesn't show up red, and the number thats largest doesn't either? I'm sorry I'm such a pain! lol... Also, do you know how to have a particular cell reference back to a spreadsheet saved to a website? Thanks "Kassie" wrote: I must apologise! Ileft out the bit about copying the formula down! =IF(F4=MAX($F$4:$F$10),"BIGDOG","") in G4. Now copy down to G10, then do the CF thing -- HTH Kassie Replace xxx with hotmail "it''''''''sh hardy" wrote: Kassie - I tried this and it didn't work =( here's what cells I'm using and I want the cell with the HIGHEST amount of sales to say bigdog F4 through F10 Thanks, Mike "Kassie" wrote: Not knowing how many regions you want, I base my answer on three. Let's say these are in A1:B3. In C1, enter =IF(B1=MAX($B$1:$B$3),"BIGDOG","") Now, conditionally format range C1:C3, cell value equal to BIGDOG, format font as Red -- HTH Kassie Replace xxx with hotmail "it''sh hardy" wrote: I work for a retail company and am trying to get the formula to show which location has the highest rate. For instance - Brandon has 25 sales, Tampa has 30, and Clearwater has 50. This formula would automatically determine which store has the highest and show up in RED saying BIGDOG! Any help is better than what I have lol! Thanks! |
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula To Show Which Cell Has The Highest Rate
Send me your file, os that I can see what you're doing
-- HTH Kassie Replace xxx with hotmail "it''''''''sh hardy" wrote: Thanks Kassie - Also, I'm tring to format the cells to do the big dog thing still and i can only get so many cells? I'm using F3-F9, G3-G9,H3-H9, and I3-I9 i get through the first two, then 3 cells into H it stops working? "Kassie" wrote: On your Home tab, just right of centre, click on Conditional Formatting, then on Highlight Cells Rules, Text that Contains. Enter BIGDOG! in the inputbox. Click on the down arrow next to "with", and select Red Text. -- HTH Kassie Replace xxx with hotmail "it''''''''sh hardy" wrote: 2007... Sorry for delay! "Kassie" wrote: Which version of Excel do you use? -- HTH Kassie Replace xxx with hotmail "it''''''''sh hardy" wrote: Ok that worked!!! thank you!!! But when I do the CF it doesn't show up red, and the number thats largest doesn't either? I'm sorry I'm such a pain! lol... Also, do you know how to have a particular cell reference back to a spreadsheet saved to a website? Thanks "Kassie" wrote: I must apologise! Ileft out the bit about copying the formula down! =IF(F4=MAX($F$4:$F$10),"BIGDOG","") in G4. Now copy down to G10, then do the CF thing -- HTH Kassie Replace xxx with hotmail "it''''''''sh hardy" wrote: Kassie - I tried this and it didn't work =( here's what cells I'm using and I want the cell with the HIGHEST amount of sales to say bigdog F4 through F10 Thanks, Mike "Kassie" wrote: Not knowing how many regions you want, I base my answer on three. Let's say these are in A1:B3. In C1, enter =IF(B1=MAX($B$1:$B$3),"BIGDOG","") Now, conditionally format range C1:C3, cell value equal to BIGDOG, format font as Red -- HTH Kassie Replace xxx with hotmail "it''sh hardy" wrote: I work for a retail company and am trying to get the formula to show which location has the highest rate. For instance - Brandon has 25 sales, Tampa has 30, and Clearwater has 50. This formula would automatically determine which store has the highest and show up in RED saying BIGDOG! Any help is better than what I have lol! Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there an Excel formula to show the highest letter in a row? | Excel Worksheet Functions | |||
Is there an Excel formula to show the highest letter in a row? | Excel Discussion (Misc queries) | |||
Is there an Excel formula to show the highest letter in a row? | Excel Discussion (Misc queries) | |||
How do I get a graph to show the highest value at the bottom | Charts and Charting in Excel | |||
tracking a no show rate at a 40+ doctor's office by physician | Setting up and Configuration of Excel |