Microsoft@Joe McDaid @Sergei Baklan @Wyn Hopkins @Bill Jelen
Hi Everyone,
Used the following formula in Cell A13. I have attached a picture to show the original data and data fetched using FILTER Function.
Cell A13 =FILTER($A$5:$BU$10,$A$5:$A$10<>"","")
What is the reason that I keep loosing the Formatting while using the Filter Dynamic Array Function. Logically if one is filtering the data then the Formatting of the original data is supposed to be intact. Also in case original data is having an empty cell, Value 0 is being returned which is strange.
I can understand about Conditional Formatting, but what about other formatting ?
In the Second Scenario, I need to Fetch only a few Columns from the Original Data, So I had pasted the Header manually (Only Required Columns)
Cell A22 =FILTER($A$6:$BU$10,$A$6:$A$10<>"","")
If we use Advanced Filters, we can fetch data for the required columns, but here I must have to fetch data for the entire range mentioned or need to mention different "array" for each column.
JoeMcDaid Sir Isn't it possible to have
--an extra option in FILTER Function Syntax to preserve or not the Original Format of the Data ?
--an extra option in FILTER Funtion Syntax to refer to the Header Column so that out of the Entire range, data for only the desired columns is fetched.
In that way one would be able to generate a desired report alongwith the Headers (or with the desired Headers) without any hitch, while keeping the Original Format Intact.
