Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Need help with an IF formula, which is based on adjacent cells being in the Top 30% of a range Need help with an IF formula, which is based on adjacent cells being in the Top 30% of a range
Register FAQ

Reply
 
Thread Tools Display Modes
  #1  
Old 07-24-2017, 11:22 PM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Need help with an IF formula, which is based on adjacent cells being in the Top 30% of a range Windows 7 64bit Need help with an IF formula, which is based on adjacent cells being in the Top 30% of a range Office 2010 64bit
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
It would be much easier if you had posted a sheet as requested.
As I and other members do not have the same regional settings it will take copy pasting the data will require tweaking to get dates and times OK.
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #2  
Old 07-25-2017, 04:10 AM
FarStar FarStar is offline Need help with an IF formula, which is based on adjacent cells being in the Top 30% of a range Windows 10 Need help with an IF formula, which is based on adjacent cells being in the Top 30% of a range Office 2016
Novice
Need help with an IF formula, which is based on adjacent cells being in the Top 30% of a range 		 
Join Date: Jul 2017
Posts: 10
FarStar is on a distinguished road
Default
Quote:
Originally Posted by Pecoflyer View Post
It would be much easier if you had posted a sheet as requested.
As I and other members do not have the same regional settings it will take copy pasting the data will require tweaking to get dates and times OK.
My apologies. I don't understand what you mean when you say you want "a sheet".
Reply With Quote
Reply

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
Distribute text in one cell across a range of cells (overcoming selection.range.cells.count bug) slaycock Word VBA 0 02-18-2017 07:00 AM
Conditional formating all cells in an array based on adjacent cells deejay Excel 6 12-20-2016 12:00 PM
Need help with an IF formula, which is based on adjacent cells being in the Top 30% of a range Excel Formula: return a range of cells that match tinfanide Excel 4 08-30-2014 07:03 AM
Color-fill a range of cells, based on text in a different sheet. Possible? unittwentyfive Excel 2 06-01-2014 06:48 AM
Need help with an IF formula, which is based on adjacent cells being in the Top 30% of a range Sum Formula in the range with Numeric and NonNumeric data cells Spanec Excel 2 01-12-2012 09:15 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:53 PM.

Contact Us - Privacy Statement - Top

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