I need a formula that will extract data from a column in excel, making sure to exclude any repeated data in the column. The data range is Column M from Row 34 to 50. Also, if a cell in that column is empty, the formula should exclude that as well. Thanks for your help!
How about using a pivot table and de-selecting blanks?
www.cpearson.com/excel/pivots.htm
Life's a spreadsheet, Excel!
Say thanks, Click *
Well I need this to work automatically since many people on different computers will be using the form that this is on.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks