Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 06-29-2017, 12:20 PM
ddansie ddansie is offline Combined MAX and IF statements? Windows 7 32bit Combined MAX and IF statements? Office 2013
Novice
Combined MAX and IF statements?
 
Join Date: Jun 2017
Location: Utah
Posts: 6
ddansie is on a distinguished road
Default Combined MAX and IF statements?

I am using Excel 2013.


I have two sheets, 1st with the raw data, 2nd for a summary page.
Raw Data Page:
Column A List of locations
Column B Numbers
In Row 1 column B I have a MAX statement which gives me my MAX number.

Summary Page:
I want to be able to list the location that has the MAX number with the number next to it.

Any help would be greatly appreciated.

-Dale
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Combined MAX and IF statements? Odd Result In Combined Merged Time Fields JennEx Mail Merge 9 04-29-2017 08:58 AM
Combined MAX and IF statements? Why are my Macros combined into a single module? Cyberseeker Excel Programming 1 04-02-2017 02:43 AM
Combined MAX and IF statements? Can Text Label & PAGE Field be combined? binar Word 1 02-11-2013 03:07 AM
combined in-box for webmail accounts sonoman Outlook 1 07-19-2011 02:50 PM
word and excel combined jasperman Word 1 08-23-2010 06:49 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:13 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft