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 |