-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
giving
-
M
Array to bring in a list of unique values
I have the following formula that is currently giving me a list of unique names based on a condition in cell E2: {=IF(COUNTIFS('MASTER ATTEND'!$A$10:$B$242,$E$2)<ROWS($B$10:B10),"",INDEX('MASTER ATTEND'!$O$10:$O$242,SMALL(IF($E$2='MASTER ATTEND'!$A$10:$B$242,ROW('MASTER...- mattjpep
- Thread
- based giving list names unique
- Replies: 3
- Forum: Excel Questions
-
A
Need a Formula (For deciding which customer is giving most profit)
Hi Gyus, I am a beginner in this forum. In my sheet attached below, I have 3 columns. A=S.No B=Customer C=Profit I want to calculate automatically, which customer is giving most profit out of these? below is link of my file Customer giving most profit.xlsx - Google Drive- ahmad08
- Thread
- a=s.no b=customer customer giving profit
- Replies: 4
- Forum: Excel Questions
-
S
Find Closest Upper value with multiple criterias
Hello everyone, I have a challenge for you :) In the table below, I would like to have a formula (going from D5 to D19) which is giving me the closest upper "Total Hours" value when the C column is in state "TRUE". Some formulas were tried, but it was always giving me B17 results instead of...- Spartanjuli1
- Thread
- giving hours total upper years
- Replies: 3
- Forum: Excel Questions
