Hi I'm trying to filter data between 3 different columns. I want it so the data filtered so data in column a is smaller than column b, which is smaller than column c. I try to filter but it only allows me to use filter criteria from the individual column.
To filter data based on conditions involving multiple columns, you will need to use a custom formula in the filter feature. Here's how you can do it:
1. Select the range of data that you want to filter.
2. Go to the "Data" menu and click on "Create a Filter" or use the Ctrl + Shift + L (Windows) or Command + Shift + L (Mac) keyboard shortcut. This will add filter icons to the headers of your columns.
3. Click on the filter icon in the header of the column you want to filter (column A in this case).
4. In the filter menu, click on "Filter by condition" or "Filter by formula."
5. In the custom formula field, enter the formula that represents your desired condition. In this case, the formula should be "A1 < B1 and B1 < C1" if you want values in column A to be smaller than values in column B, and values in column B to be smaller than values in column C. Note that "A1," "B1," and "C1" represent the first row of data in each respective column.
6. Click "OK" or press Enter to apply the filter.
Repeat the same steps for each column to set the desired conditions in each column. The final filtered data will include only the rows where the conditions in all three columns are met.
Remember to adjust the cell references in the formula (e.g., A1, B1, C1) based on your actual data range.