Reorganize Your Data using this FILTER function. 🤯 #excel #exceltips #tutorial

Reorganize Your Data using this FILTER function.

Follow these steps to do the task:
✅ Prepare Your Data
✅ Use the Filter Function, Syntex: =FILTER(array, include, [if_empty])

Alternate Method:

✅ Go to the column where you want to filter the data.
✅ use this function: =FILTER(selected the columns, extracted value) and hit enter.

Now you data is arranged.
Follow us for more excel tips and tricks. Excel guides, shortcuts, workhacks.

#excel #exceltips #exceltricks #spreadsheets
#sheets #corporate #finance #workhacks #tutorial #accounting