MAXIF and return another column

R

redzhell

New Member
Joined
Mar 8, 2018
Messages
12
Hi,

Please can somebody help?​
The purpose is to get the Max of column C for each AssetID(column B) and then return whether it’s a Cross Arm or Pole but I’d need to returnall values for Poles and Cross Arm if the highest occurs more than once per AssetID.

So just for the below example, the Max is
4.20825744623599 which is true for both the L Pole and R Pole. How would I write the formula around my MAXIF so that it returns 'L Pole, R Pole'?​
<strike>
</strike>
I do have a spreadsheet I can attach but can't see a way of attaching it.





[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD]10029396C<strike></strike>
[/TD]
[TD]<strike></strike>KPO-TMU-A0008<strike></strike>
[/TD]
[TD]<strike></strike>2.43650068130681<strike></strike>
[/TD]
[TD]<strike></strike>[TABLE="width: 180"]
<colgroup><col></colgroup><tbody>[TR]
[TD]CROSS ARM[/TD]
[/TR]
</tbody>[/TABLE]
<strike></strike>
[/TD]
[/TR]
[TR]
[TD]<strike></strike>[TABLE="width: 131"]
<colgroup><col></colgroup><tbody>[TR]
[TD]10029396L[/TD]
[/TR]
</tbody>[/TABLE]
<strike></strike>
[/TD]
[TD]KPO-TMU-A0008<strike></strike>
[/TD]
[TD]<strike></strike>4.20825744623599<strike></strike>
[/TD]
[TD]<strike></strike>[TABLE="width: 180"]
<colgroup><col></colgroup><tbody>[TR]
[TD]L POLE[/TD]
[/TR]
</tbody>[/TABLE]
<strike></strike>
[/TD]
[/TR]
[TR]
[TD]<strike></strike>[TABLE="width: 131"]
<colgroup><col></colgroup><tbody>[TR]
[TD]10029396R[/TD]
[/TR]
</tbody>[/TABLE]
<strike></strike>
[/TD]
[TD]KPO-TMU-A0008<strike></strike>
[/TD]
[TD]<strike></strike>
4.20825744623599​
<strike style="background-color: transparent; border-collapse: collapse; color: rgb(34, 34, 34); font-family: Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif; font-size: 13px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-decoration: line-through; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; width: auto; word-spacing: 0px;"></strike><strike></strike>
[/TD]
[TD]<strike></strike>[TABLE="width: 180"]
<colgroup><col></colgroup><tbody>[TR]
[TD]R POLE[/TD]
[/TR]
</tbody>[/TABLE]

[/TD]
[/TR]
</tbody>[/TABLE]
<strike></strike>

<strike></strike>

[TABLE="width: 519"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
<strike></strike>
 

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.
Sort by date Sort by votes
Try:


Book1
ABCDEFG
1AAsset IDCDAsset IDValue
210029396CKPO-TMU-A00082.4365CROSS ARMKPO-TMU-A0008L POLE, R POLE
310029396LKPO-TMU-A00084.20826L POLE
410029396RKPO-TMU-A00084.20826R POLE
Sheet3
Cell Formulas
RangeFormula
G2{=TEXTJOIN(", ",1,IF(C2:C4=MAXIFS(C:C,B:B,F2),D2:D4,""))}
Press CTRL+SHIFT+ENTER to enter array formulas.
 
Upvote 0
Hi Eric,

Thank you so much - I tried to use the formula for a much larger dataset but failed. I've got just over 31,000 rows so I tweaked C2:C4 and D2:D4 to extend accordingly but didn't work.

In the F column, I've got just over 13,000 rows with the unique AssetIDs that are being matched up on column B. Also Asset IDs could have anywhere between 1 to 5 rows with different properties on the D column so I would need to display all of D with the Max of C.

Hope that makes sense.

Am currently trying to figure out a way to post a snapshot of a slightly bigger dataset on here but also failing on that!
 
Upvote 0
Hi, Can you tell which version of excel are you using? See if you have TEXTJOIN function.

If you have try below, slight tweak in the formula in #2 :


Book1
ABCDEFG
1ABCDAsset IDValue
210029396CKPO-TMU-A00082.436500681CROSS ARMKPO-TMU-A0008L POLE, R POLE
310029396LKPO-TMU-A00084.208257446L POLE
410029396RKPO-TMU-A00084.208257446R POLE
Sheet9
Cell Formulas
RangeFormula
G2{=TEXTJOIN(", ",1,IF((($C$2:$C$4)*($B$2:$B$4=F2))=MAXIFS($C$2:$C$4,$B$2:$B$4,F2),$D$2:$D$4,""))}
Press CTRL+SHIFT+ENTER to enter array formulas.
 
Upvote 0
Aryatect said:
Hi, Can you tell which version of excel are you using? See if you have TEXTJOIN function.
Click to expand...

Hi - I am using 2016 so TEXTJOIN works.

I've finally worked out how to paste from Excel using the add-ins! Here's a snapshot of my data sorted via AssetID. The left handside contains all the data for each asset and the right handside contains the unique Asset IDs with what should be a concatenation of Pole and Cross Arm if joint Max HI (column C). I've copied the formula you've kindly given and just extended it to 31884 but all are coming up as errors.

What am I doing wrong?

ABCDEFG
10175251MAHA-DOB-A0241A1.362298087M POLEAHA-DOB-A0241A#VALUE!
10274203CAHA-DOB-A02421.580660109CROSSARMAHA-DOB-A0242#VALUE!
10274203MAHA-DOB-A02420.889005093M POLEAHA-DOB-A0243#VALUE!
10175258MAHA-DOB-A02437.401968309M POLEAHA-DOB-A0244#VALUE!
10175258CAHA-DOB-A02436.118525986CROSSARMAHA-DOB-A0245#VALUE!
10274204MAHA-DOB-A02440.941667698M POLEAHA-DOB-A0246#VALUE!
10175264CAHA-DOB-A02453.09334561CROSSARMAHA-DOB-A0247#VALUE!
10175264MAHA-DOB-A02451.362298087M POLEAHA-DOB-A0248#VALUE!
10175267MAHA-DOB-A02467.401968309M POLEAHA-DOB-A0249#VALUE!
10175267CAHA-DOB-A02467.401968309CROSSARMAHA-DOB-A0250#VALUE!
10175270MAHA-DOB-A02471.362298087M POLEAHA-DOB-A0251#VALUE!
10175270CAHA-DOB-A02473.09334561CROSSARMAHA-DOB-A0252#VALUE!
10175273MAHA-DOB-A02481.744746795M POLEAHA-DOB-A0253#VALUE!
10298647MAHA-DOB-A02490.80383286M POLEAHA-DOB-A0254#VALUE!
10175279CAHA-DOB-A02503.09334561CROSSARMAHA-DOB-A0255#VALUE!
10175279MAHA-DOB-A02501.362298087M POLEAHA-DOB-A0256#VALUE!
12053027CAHA-DOB-A0251NULLCROSSARMAHA-DOB-A0257#VALUE!
12053027MAHA-DOB-A0251NULLM POLEAHA-DOB-A0258#VALUE!
13161276LAHA-DOB-A0252NULLL POLEAHA-DOB-A0259#VALUE!
13161276RAHA-DOB-A0252NULLR POLEAHA-DOB-A0260#VALUE!
10175288MAHA-DOB-A02537.401968309M POLEAHA-DOB-A0261#VALUE!
10175288CAHA-DOB-A02536.118525986CROSSARMAHA-DOB-A0262#VALUE!
10175291MAHA-DOB-A02545.5M POLEAHA-DOB-A0263#VALUE!
10175294MAHA-DOB-A02551.023057647M POLEAHA-DOB-A0264#VALUE!
10175294CAHA-DOB-A02553.09334561CROSSARMAHA-DOB-A0265#VALUE!
10316356CAHA-DOB-A02564.541385053CROSSARMAHA-DOB-A0266#VALUE!
10316356MAHA-DOB-A02561.282592096M POLEAHA-DOB-A0267#VALUE!
10319129CAHA-DOB-A02575.076351457CROSSARMAHA-DOB-A0268#VALUE!
10319129MAHA-DOB-A02571.522207127M POLEAHA-DOB-A0269#VALUE!

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]
[TD="bgcolor: #1F4E78"]C1 (UT_HI197)[/TD]
[TD="bgcolor: #1F4E78"]Asset ID[/TD]
[TD="bgcolor: #1F4E78"]HI[/TD]
[TD="bgcolor: #548235"]Pole and Cross Arm Identifier[/TD]

[TD="bgcolor: #548235"]Distinct AssetID[/TD]
[TD="bgcolor: #FF0000"]Return Cross Arm or Pole based on Max HI[/TD]

[TD="align: center"]2[/TD]

[TD="align: center"]3[/TD]

[TD="align: center"]4[/TD]

[TD="align: center"]5[/TD]

[TD="align: center"]6[/TD]

[TD="align: center"]7[/TD]

[TD="align: center"]8[/TD]

[TD="align: center"]9[/TD]

[TD="align: center"]10[/TD]

[TD="align: center"]11[/TD]

[TD="align: center"]12[/TD]

[TD="align: center"]13[/TD]

[TD="align: center"]14[/TD]

[TD="align: center"]15[/TD]

[TD="align: center"]16[/TD]

[TD="align: center"]17[/TD]

[TD="align: center"]18[/TD]

[TD="align: center"]19[/TD]

[TD="align: center"]20[/TD]

[TD="align: center"]21[/TD]

[TD="align: center"]22[/TD]

[TD="align: center"]23[/TD]

[TD="align: center"]24[/TD]

[TD="align: center"]25[/TD]

[TD="align: center"]26[/TD]

[TD="align: center"]27[/TD]

[TD="align: center"]28[/TD]

[TD="align: center"]29[/TD]

[TD="align: center"]30[/TD]

</tbody>
1509​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Array Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]
[TH="width: 10"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]G2[/TH]
[TD="align: left"]{=TEXTJOIN(", ",1,IF([COLOR=#0]([COLOR=#00]([COLOR=#00b00]$C$2:$C$31884)*([COLOR=#00b00]$B$2:$B$31884=F2[/COLOR])[/COLOR])=MAXIFS([COLOR=#00]$C$2:$C$31884,$B$2:$B$31884,F2[/COLOR]),$D$2:$D$31884,""[/COLOR])[/COLOR])}[/TD]
[/TR]
</tbody>[/TABLE]
Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}.
Note: Do not try and enter the {} manually yourself[/TD]
[/TR]
</tbody>[/TABLE]
 
Upvote 0
Hi, so I got your problem, it is happening because of NULL text in some of the columns. Trying to find a way around it
 
Upvote 0
maybe like this?

[Table="width:, class:head"]
[tr=bgcolor:#FFFFFF][td=bgcolor:#70AD47]Asset ID[/td][td=bgcolor:#70AD47]Max[/td][td=bgcolor:#70AD47]Pole and Cross Arm Identifier[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]AHA-DOB-A0243[/td][td=bgcolor:#E2EFDA]
7.401968309​
[/td][td=bgcolor:#E2EFDA]M POLE, CROSSARM[/td][/tr]

[tr=bgcolor:#FFFFFF][td]AHA-DOB-A0253[/td][td]
7.401968309​
[/td][td]M POLE, CROSSARM[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]AHA-DOB-A0246[/td][td=bgcolor:#E2EFDA]
7.401968309​
[/td][td=bgcolor:#E2EFDA]M POLE, CROSSARM[/td][/tr]

[tr=bgcolor:#FFFFFF][td]AHA-DOB-A0254[/td][td]
5.5​
[/td][td]M POLE[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]AHA-DOB-A0257[/td][td=bgcolor:#E2EFDA]
5.076351457​
[/td][td=bgcolor:#E2EFDA]CROSSARM, M POLE[/td][/tr]

[tr=bgcolor:#FFFFFF][td]AHA-DOB-A0256[/td][td]
4.541385053​
[/td][td]CROSSARM, M POLE[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]AHA-DOB-A0255[/td][td=bgcolor:#E2EFDA]
3.09334561​
[/td][td=bgcolor:#E2EFDA]M POLE, CROSSARM[/td][/tr]

[tr=bgcolor:#FFFFFF][td]AHA-DOB-A0250[/td][td]
3.09334561​
[/td][td]CROSSARM, M POLE[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]AHA-DOB-A0245[/td][td=bgcolor:#E2EFDA]
3.09334561​
[/td][td=bgcolor:#E2EFDA]CROSSARM, M POLE[/td][/tr]

[tr=bgcolor:#FFFFFF][td]AHA-DOB-A0247[/td][td]
3.09334561​
[/td][td]M POLE, CROSSARM[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]AHA-DOB-A0248[/td][td=bgcolor:#E2EFDA]
1.744746795​
[/td][td=bgcolor:#E2EFDA]M POLE[/td][/tr]

[tr=bgcolor:#FFFFFF][td]AHA-DOB-A0242[/td][td]
1.580660109​
[/td][td]CROSSARM, M POLE[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]AHA-DOB-A0241A[/td][td=bgcolor:#E2EFDA]
1.362298087​
[/td][td=bgcolor:#E2EFDA]M POLE[/td][/tr]

[tr=bgcolor:#FFFFFF][td]AHA-DOB-A0244[/td][td]
0.941667698​
[/td][td]M POLE[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]AHA-DOB-A0249[/td][td=bgcolor:#E2EFDA]
0.80383286​
[/td][td=bgcolor:#E2EFDA]M POLE[/td][/tr]

[tr=bgcolor:#FFFFFF][td]AHA-DOB-A0252[/td][td]
0​
[/td][td]L POLE, R POLE[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]AHA-DOB-A0251[/td][td=bgcolor:#E2EFDA]
0​
[/td][td=bgcolor:#E2EFDA]CROSSARM, M POLE[/td][/tr]
[/table]
 
Upvote 0
Aryatect said:
Can you replace NULL with 1 or any big number like 10000?
Click to expand...

Sorry I usually work with SQL and forgot that NULLs are texts in Excel. I couldn't replace them with any other number as that will affect the MAXIFS calculation so I have removed them and the NULL cells are just blank.

I think we're nearly there as the results are mostly coming through but would need to tweak the formula as the ones with just blank cells for certain AssetIDs are coming up as #VALUE ! error. How do I then get the CrossArm and Pole if the AssetIDs have no values in HI column (C)?
​
 
Upvote 0
sandy666 said:
maybe like this?

[TABLE="class: head"]
<tbody>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #70AD47"][COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]Asset ID[/COLOR][/TD]
[TD="bgcolor: #70AD47"][COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]Max[/COLOR][/TD]
[TD="bgcolor: #70AD47"][COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]Pole and Cross Arm Identifier[/COLOR][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #E2EFDA"]AHA-DOB-A0243[/TD]
[TD="bgcolor: #E2EFDA"]
7.401968309​
[/TD]
[TD="bgcolor: #E2EFDA"]M POLE, CROSSARM[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]AHA-DOB-A0253[/TD]
[TD]
7.401968309​
[/TD]
[TD]M POLE, CROSSARM[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #E2EFDA"]AHA-DOB-A0246[/TD]
[TD="bgcolor: #E2EFDA"]
7.401968309​
[/TD]
[TD="bgcolor: #E2EFDA"]M POLE, CROSSARM[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]AHA-DOB-A0254[/TD]
[TD]
5.5​
[/TD]
[TD]M POLE[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #E2EFDA"]AHA-DOB-A0257[/TD]
[TD="bgcolor: #E2EFDA"]
5.076351457​
[/TD]
[TD="bgcolor: #E2EFDA"]CROSSARM, M POLE[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]AHA-DOB-A0256[/TD]
[TD]
4.541385053​
[/TD]
[TD]CROSSARM, M POLE[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #E2EFDA"]AHA-DOB-A0255[/TD]
[TD="bgcolor: #E2EFDA"]
3.09334561​
[/TD]
[TD="bgcolor: #E2EFDA"]M POLE, CROSSARM[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]AHA-DOB-A0250[/TD]
[TD]
3.09334561​
[/TD]
[TD]CROSSARM, M POLE[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #E2EFDA"]AHA-DOB-A0245[/TD]
[TD="bgcolor: #E2EFDA"]
3.09334561​
[/TD]
[TD="bgcolor: #E2EFDA"]CROSSARM, M POLE[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]AHA-DOB-A0247[/TD]
[TD]
3.09334561​
[/TD]
[TD]M POLE, CROSSARM[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #E2EFDA"]AHA-DOB-A0248[/TD]
[TD="bgcolor: #E2EFDA"]
1.744746795​
[/TD]
[TD="bgcolor: #E2EFDA"]M POLE[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]AHA-DOB-A0242[/TD]
[TD]
1.580660109​
[/TD]
[TD]CROSSARM, M POLE[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #E2EFDA"]AHA-DOB-A0241A[/TD]
[TD="bgcolor: #E2EFDA"]
1.362298087​
[/TD]
[TD="bgcolor: #E2EFDA"]M POLE[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]AHA-DOB-A0244[/TD]
[TD]
0.941667698​
[/TD]
[TD]M POLE[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #E2EFDA"]AHA-DOB-A0249[/TD]
[TD="bgcolor: #E2EFDA"]
0.80383286​
[/TD]
[TD="bgcolor: #E2EFDA"]M POLE[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]AHA-DOB-A0252[/TD]
[TD]
0​
[/TD]
[TD]L POLE, R POLE[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #E2EFDA"]AHA-DOB-A0251[/TD]
[TD="bgcolor: #E2EFDA"]
0​
[/TD]
[TD="bgcolor: #E2EFDA"]CROSSARM, M POLE[/TD]
[/TR]
</tbody>[/TABLE]
Click to expand...

Hi - you seem to have it right as you're getting results for ones with blank HIs like for
AHA-DOB-A0252 and
AHA-DOB-A0251​
​
. What is the formula please?
 
Upvote 0
You must log in or register to reply here.

Similar threads

H
  • Question Question
Create report from Columns differences.
Replies
0
Views
542
HerClau
H
D
  • Question Question
Problem with Match function...
Replies
3
Views
762
DizzyDoodle
D
A
  • Question Question
Excel Challenge from a friend - I failed can you solve it?
Replies
5
Views
1K
sandy666
sandy666
W
  • Question Question
return value based on matrix column name and row name
Replies
5
Views
661
AlanY
A
W
  • Question Question
Formula to Sum Cells when value changes in another Column
Replies
6
Views
6K
WednesdayC
W

Forum statistics

Threads
1,224,820
Messages
6,181,162
Members
453,021
Latest member
Justyna P

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top