Formula Issues - Filtering data to new sheet.

Attachment 304899First, sorry for not reading the rules before posting! My bad….am sure everyone has what they think is a dire emergency! Sorry!

I have been working on the same spreadsheet for 4 days now - and can't seem to get past a certain point. Any advice?

The sheet is pretty simple - I am trying to track the division of a personal estate.

First page has columns for item number, then item, drop down menus for location in house, value and "picked by". So 5 total.

Second page is a "summary of division" listing number of items, median cost of items and complete value. Below is a breakdown of the total value of items that each individual selected.

While the majority of items have yet to to priced - the price range is there - so the format (whatever is it) should work.

Any advice? Please help…I am at my wits end.

Cheers.

JP

Welcome to the forum.

We'd like to help you but first..

Pls take some minutes to read forum rules and specially-in this case- rule#1 and amend your title
Then anyone will be able to help you.