| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Mode - IF?
If I have a list of say Part Qty FFF000 1 FFF001 2 FFF000 1 FFF000 1 FFF001 2 How do I for example get the mode of the qty where Part = FFF000. I have a list with over 5000 lines that I need a solution for! -- Crosswire ------------------------------------------------------------------------ Crosswire's Profile: http://www.excelforum.com/member.php...fo&userid=8214 View this thread: http://www.excelforum.com/showthread...hreadid=492637 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Mode - IF?
Hi!
Try this: Entered as an array using the key combo of CTRL,SHIFT,ENTER: =MODE(IF(A2:A6="FFF000",B2:B6)) Or: C1 = FFF000 =MODE(IF(A2:A6=C1,B2:B6)) Biff "Crosswire" wrote in message ... If I have a list of say Part Qty FFF000 1 FFF001 2 FFF000 1 FFF000 1 FFF001 2 How do I for example get the mode of the qty where Part = FFF000. I have a list with over 5000 lines that I need a solution for! -- Crosswire ------------------------------------------------------------------------ Crosswire's Profile: http://www.excelforum.com/member.php...fo&userid=8214 View this thread: http://www.excelforum.com/showthread...hreadid=492637 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Mode - IF?
Thanks Biff, worked perfectly! -- Crosswire ------------------------------------------------------------------------ Crosswire's Profile: http://www.excelforum.com/member.php...fo&userid=8214 View this thread: http://www.excelforum.com/showthread...hreadid=492637 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to turn off design mode | Excel Worksheet Functions | |||
| Arithmetical Mode Value for Filtered cells in Multiple Non-Adjacent columns | Excel Worksheet Functions | |||
| Mode Function with Criteria | Excel Worksheet Functions | |||
| Combo Box goes to edit mode even if design mode is in OFF position | Excel Discussion (Misc queries) | |||
| coverting answer from Radian mode to degree mode | Excel Worksheet Functions | |||
Linear Mode
