Microsoft Office Questions? Ask a IT Expert for Support ASAP
I'm using Excel 2011 for MAC and trying to use Advanced Filter and asking it to filter unique records only but it doesn't filter.
Thanks for using JustAnswer. My name isXXXXX will do whatever I can to answer your question
how exactly are you trying to filter the data?
There are duplicate profile ID's in the first column. I want to return the same list but any duplicates only 1 of the rows will show.
ie. Row 2 and 3 both have the same profile ID. I want my new list to only show Row 2 for example
and regular filters do not work?
I filtered by colour but it removes all the unique profile id rows.
I tried "remove duplicates" but it removes every row that has a matching profile ID..so in that process row 2 and 3 were removed...which isn't what I want
filtering isn't going to do it then
I dont know how it works on mac
but on windows when I do remove duplicates it does keep each row at least 1x
so do you want to send the file to me
have me run it
Oh I thought because I put "for MAC" in the subject line, I would get someone who knows excel for mac?
i know enough to know that its functionality is limited
i mean if you send the file
i run it
then send the file back
I did upload the file and it shows as an attachment on the window I'm on
ok please try again
because I never got the attachment
is it easier for me to email...or attach it here...stand by
Did that work?
give me a minute to look at it
let me know if this is what you were looking for
Yes that is what result I was looking for...
Ok what is the secret?
secret is being on a PC
I walked into that one
sorry I am not much of a MAC fan for obvious reasons
they do have their uses
espicially in graphics
please rate when ready so I am reimbursed for my time
yeah pivot filtering is a bust on excel for mac too...
Ok...but what did you do so I can replicate?
maybe next version will work better
um not sure how it works on mac
but i higlighted all columns
Ok what did you do on the PC?
then i went to the data tab
selected remove duplicates
it gave me a window that allowed me to select withch columns
i selected only column A
then clicked ok
so if they don't give you the ability to select columns on mac
that could be the reason
can you stand by...while I try this?
make sure to remove any filters
before doing this
Ok, that worked. let me ask you. If I want it to keep the row that has the "2" in it...Speaker order column. Is there a way I can get it to remove the row with 1 in it?
not easily, remove duplicates just picks whatever is first i think
it could probably be done with a macro
but that is very involved, and I am not sure about 2011s ability to run macros well, I know it does support it, but not sure of the extent of its abilities
I guess if I re-sort it to have the row with "2" in it be first ... then run the remove duplicates...it should work?
in theory, its worth a try
if not working would require a macro
yeah...I run the other way when someone says macro...I would need to take a course I think . LOL
i would create it for an additional fee, as it goes beyond the scope of this question
No that is fine....Ok thanks
anyway, I enabled the rating buttons, now, they are the smileys underneath this chat
if you change your mind and want a macro
let me know