creating database in excel when importing a spreadsheet we will check for duplicate members thus disallowing double imports moreover if the members category value does not yet.
how to create a report on excel step 4 the new worksheet will open and you will be able to see the pivot table that you just created you can now generate the report from this table and create excel re.
excel filter drop down to clear the filter click clear in the sort filtering group in excel choose filter from the data menu and then show all its a tedious process if excel filter drop down list.