need help pulling max + or - value from a pool of numbers

		Microsoft Office Forums > Microsoft Excel > Excel
need help pulling max + or - value from a pool of numbers

FAQ

Thread Tools

Display Modes

03-09-2017, 05:40 PM

jeffreybrown jeffreybrown is offline

Windows Vista need help pulling max + or - value from a pool of numbers

Office 2007

Expert

Join Date: Apr 2016

Posts: 673

jeffreybrown has a spectacular aura about

Hi Kevin,

Based on your sample, put this in the 2nd sheet in B1 and copy down...

=IFERROR(INDEX(Sheet1!$B$1:$B$7,LARGE(IF(Sheet1!$A $1:$A$7=A1,ROW(Sheet1!$A$1:$A$7)-ROW(Sheet1!$A$1)+1),1)),"")

IMPORTANT

This is an array formula
Enter the formula >> press F2 then >> CTRL + SHIFT + ENTER
If entered correctly, the formula will be enclosed in {brackets}
Do not enter the {brackets} manually

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Central Resource Pool	OTPM	Project	3	12-01-2015 11:27 AM
Resource pool with Sharepoint	codeghi	Project	3	02-28-2014 11:39 AM
Resource Pool / export	Bec82	Project	3	08-16-2011 11:11 AM
Use only rsource pool	gdallas	Project	0	11-25-2010 01:10 PM
Need help with pulling out information	mtnguye9	Excel	6	07-24-2010 07:52 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:38 AM.