Dear All,
With reference to the attached sample file there is a [“Report file” worksheet ]by extract the date from [“Data File” worksheet] on the basis of Date change at Row”A1”.
I insert the [column “E” of CATEGORY ]in the “Report File” and entered the data manually on the basis of the data file’s column header(category). Can be possible with a help of Excel formula?
With reference to the attached sample file there is a [“Report file” worksheet ]by extract the date from [“Data File” worksheet] on the basis of Date change at Row”A1”.
I insert the [column “E” of CATEGORY ]in the “Report File” and entered the data manually on the basis of the data file’s column header(category). Can be possible with a help of Excel formula?