Finding Employee Rest

[Dexir]

Hi, i have large numbers of employee's attendance, i want to know about their rest day, how can i find with formula?
i have used the if condition, and this is some kind of lengthy. please let me know if there is an other short formula.
Thanks in advance
=IF(C2="R",$C$1,IF(D2="R",$D$1,IF(E2="R",$E$1,IF(F2="R",$F$1,IF(G2="R",$G$1,IF(H2="R",$H$1,IF(I2="R",$I$1)))))))
i am using this formula

		Mon	Tue	Wed	Thu	Fri	Sat	Sun
251590​	Sameer Hayat	P	R	P	P	P	P	P	Tue
251663​	Noman Mazhar	P	P	P	P	P	P	R	Sun
251697​	Mazhar Hayat	R	A	P	P	P	P	A	Mon
251944​	Fiaz Ahmad	CLH	P	P	P	R	A	A	Fri
251953​	Abdul Mateen	P	P	P	R	P	P	P	Thu
252324​	Yasir Nawaz	P	P	R	P	P	A	P	Wed
252409​	Azmat Ali	P	P	P	P	P	P	R	Sun
252430​	Muhammad Zeeshan An	P	P	R	P	P	P	P	Wed
252447​	Faisal Nawaz	P	P	P	P	P	R	P	Sat
252678​	Muhammad Sabir	P	P	P	P	R	P	A	Fri
253603​	Ghulam Mujtaba	P	P	P	R	P	P	P	Thu

 

[Fluff]

How about

Fluff.xlsm
	A	B	C	D	E	F	G	H	I	J
1			Mon	Tue	Wed	Thu	Fri	Sat	Sun
2	251590	Sameer Hayat	P	R	P	P	P	P	P	Tue
3	251663	Noman Mazhar	P	P	P	P	P	P	R	Sun
4	251697	Mazhar Hayat	R	A	P	P	P	P	A	Mon
5	251944	Fiaz Ahmad	CLH	P	P	P	R	A	A	Fri
6	251953	Abdul Mateen	P	P	P	R	P	P	P	Thu
7	252324	Yasir Nawaz	P	P	R	P	P	A	P	Wed
8	252409	Azmat Ali	P	P	P	P	P	P	R	Sun
9	252430	Muhammad Zeeshan An	P	P	R	P	P	P	P	Wed
10	252447	Faisal Nawaz	P	P	P	P	P	R	P	Sat
11	252678	Muhammad Sabir	P	P	P	P	R	P	A	Fri
12	253603	Ghulam Mujtaba	P	P	P	R	P	P	P	Thu
Master

Cell Formulas
Range	Formula
J2:J12	J2	=LOOKUP(2,1/(C2:I2="R"),$C$1:$I$1)

 

[Dexir]

it's working.
Thank you so much!

 

[Fluff]

You're welcome & thanks for the feedback.

 

[alansidman]

Here is an alternative means with Power Query

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Unpivoted Other Columns" = Table.UnpivotOtherColumns(Source, {"Column1", "Column2"}, "Attribute", "Value"),
    #"Filtered Rows" = Table.SelectRows(#"Unpivoted Other Columns", each ([Value] = "R")),
    #"Removed Columns" = Table.RemoveColumns(#"Filtered Rows",{"Value"}),
    #"Pivoted Column" = Table.Pivot(#"Removed Columns", List.Distinct(#"Removed Columns"[Attribute]), "Attribute", "Column2")
in
    #"Pivoted Column"

Column1	Mon	Tue	Wed	Thu	Fri	Sat	Sun
251590		Sameer Hayat
251663							Noman Mazhar
251697	Mazhar Hayat
251944					Fiaz Ahmad
251953				Abdul Mateen
252324			Yasir Nawaz
252409							Azmat Ali
252430			Muhammad Zeeshan An
252447						Faisal Nawaz
252678					Muhammad Sabir
253603				Ghulam Mujtaba

 

[Dexir]

Thank you alansidman, i just want to know the formula.