Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-22-2020, 10:00 PM
Purfleet Purfleet is offline Excel and cell contents Windows 10 Excel and cell contents Office 2019
Expert
 
Join Date: Jun 2020
Location: Essex
Posts: 345
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default

As long as the min is unique you can use =Match(min(C:C),C:C,0) to give you the row number.




However i would ask why you need to know the location of the Min number, is it for another formula?
Reply With Quote
  #2  
Old 07-22-2020, 11:17 PM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Excel and cell contents Windows 7 64bit Excel and cell contents Office 2010
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,943
Pecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond repute
Default

Does your range start in row 1?
Reply With Quote
  #3  
Old 07-23-2020, 11:10 AM
oscarlimerick oscarlimerick is offline Excel and cell contents Windows 8 Excel and cell contents Office 2013
Advanced Beginner
Excel and cell contents
 
Join Date: Jul 2020
Posts: 82
oscarlimerick is on a distinguished road
Default

Quote:
Originally Posted by Purfleet View Post
As long as the min is unique you can use =Match(min(C:C),C:C,0) to give you the row number.


However i would ask why you need to know the location of the Min number, is it for another formula?
Thanks, I tried this formula and it returned a value of row 69 so it appears to work, but I'm wondering what will happen if I have 2 cells in column c with a value of 7? The reason I need to know the row location of the min number is because my spreadsheet is a bunch of numerical values in column c that equate to a related date in column a. So I want to know what date my minimum value of 7 was achieved. your formula appears to achieve this, at least it does if the value 7 in column c is unique.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel and cell contents Copy a cell's contents across many cells cloa513 Word Tables 13 09-19-2016 11:11 PM
Excel and cell contents Selection from cell with list contents autopopulates contents of another cell markharper80 Excel 3 02-16-2015 04:18 PM
Excel and cell contents Assign the value of a cell as a cell reference of another cell in Excel 2010 - How to? bharathkumarst Excel 7 10-13-2014 10:25 AM
Can anyone here tweek this macro for renaming Excel files based on a cell's contents? chrisd2000 Excel Programming 6 07-01-2014 01:53 PM
Excel and cell contents cut&paste cell contents AND formatting cglenn Word Tables 2 08-24-2011 07:04 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:06 PM.


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