PDA

View Full Version : [SOLVED] Help with an array formula



Mati44
12-22-2017, 07:14 AM
I have this formula
=IFERROR(IF(COUNTIF($K2:$S2,5)>=COLUMNS($K2:$S2),5,””),"") to arrange same numbers in the cells like (1,1,1), (2,2,2,2), etc. It normaly works without a problem. but when I apply this formula to the data I have on k3:s3 which has this array formula
{=SMALL(--RIGHT(A2:I2,1),{1,2,3,4,5,6,7,8,9})}, the original formula doesn't work. How can I fix this problem? please. thanks.

p45cal
12-22-2017, 01:57 PM
Is the attached what you're after?
I was working with Excel 2003, so you may want to put the IFERROR part back in - but you may not find it necessary.

p45cal
12-22-2017, 02:09 PM
Groan.
Having spent some time preparing you this solution I found you already had an answer hours ago, at least at https://www.mrexcel.com/forum/excel-questions/1036313-alternative-excel-formula.html
Read the blinking rules, and while your at it, see why here: http://www.excelguru.ca/content.php?184-A-message-to-forum-cross-posters
In the future, consider how willing to put time into finding you a solution I will be? We're humans, not machines.

Mati44
12-23-2017, 07:31 AM
Hi p45cal, I am sorry for the late reply and about my other post too. I couldn't find the answer on the other post you mentioned, but I posted the solution myself there so someone else may use it too. Before coming up with the solution, I wanted to ask here too to get a quick result. because it was urgent. thanks for your answer and time really.