Hello-Wondering if you have tutorial to solve for the following: I have 4 lists from 4 different sessions (March-April-May-June) containing attendees that were present for each session. I need to find out which individuals were in attendance for just one session, or two sessions or three sessions or all four sessions. What is the best way to achieve this? Thanks!
@sharonjones3386
10 ай бұрын
did start with this and now I've seen =UNIQUE so you can use it on another tab, just trying to see if I can filter it on another column this is proving a little tricky - JUST SEEN YOUR NEW VIDEO!!!! BRILLIANT HELPED ME LOADS
@ITPFS
2 жыл бұрын
What if I need to find cases where a sales person has only sold one line item/product to a business in a list full of cases where sales persons have sold multiple line items/products to a single business?
@yuvonnebanks775
3 жыл бұрын
How can I create a list of names so that I don't have to type the same names everyday?
@AbdulRauf-hj3rk
5 жыл бұрын
After sort out of unique values, i need sum of unique values in each customer separately how could we done this
@swapniljain856
5 жыл бұрын
@Mahima Papnai you can use sumif.
@hyztutorliveclass761
4 жыл бұрын
Its shows that data range is not valid or missing
@evolutionclouds
13 күн бұрын
You can use the UNIQUE formula and it will achieve exactly the same result plus you can use the formula on any worksheet
@manasranjanjena5739
3 жыл бұрын
After hovering around here n there finally I found this useful tutorial. Thanks bro
@MAYURROKDE
4 жыл бұрын
Hi.. i was trying to find the unique values from the filtered column. This method not seems to be working as it considering all the values from that particular column. Any suggestion on how to find unique data from the filtered column???
@chrismeredith7935
2 жыл бұрын
Thanks so much mate. This is an enormous help. I have liked the video and subscribed to your newsletter. Thanks again.
@stevenshih
4 жыл бұрын
Thank you very much! Simple but since people like you spend your time recording to educate us. It truly helps a lot. Video with example is always more intuitive
@vikashsinha2310
10 ай бұрын
Thanks
@magnus8488
3 жыл бұрын
👍
@richikarajoria7867
Жыл бұрын
How can I find count of repeated data of 10000 rows and add the amount of count also
@rahulmanohar90
2 жыл бұрын
Thankyou
@chapakokotv
3 жыл бұрын
This is very helpful.
@littlekidscartoonplanet
Жыл бұрын
Hi Sir, may you write of vba code lis uniques?
@idiomatic_person
8 ай бұрын
Thanks friend
@danielifrim6295
3 жыл бұрын
Great, Great, amazing! You re doing a wonderful job! Thanks a lot
@shashicreativethings6817
2 жыл бұрын
REALLY ITS HELPFUL AWESOME VIDEO THANK YOU SIR
@tombates3711
6 жыл бұрын
I tried this in Excel 2016 and it copied the formatting too! Two other disadvantages: 1) the Copy operation is one-shot, i.e. that new table is not updated automatically when changes are made to the table, and 2) an existing standard filter bar is removed when the advanced filter is used. Thanks for the information.
@c.m.7037
3 жыл бұрын
How do you do it w here it is updated?
@salmabanawan2670
Жыл бұрын
Hi, this was so informative!! I want to know how I can select the data from more than one column and extract the unique entries only.
@doratarfa6547
2 жыл бұрын
Hello Excel Campus, I am trying to manage a database for a plastic waste recyling project. Households bring their plastice waste and exchange it for cash. I have assigned unque ids to these houses but the challenge is these houses will come more than once but i want to capture their names once to avoid double counting but also caputure the kg of plastic they bring and the money the make. Do you have any tips or advise on how i can go about this?
@manishupadhyay7731
3 жыл бұрын
Woow, I love you. Amazing, woow man I love you the way you teachs
@kevind4061
2 жыл бұрын
This doesn't work for me. I have a long list of names in one column but the filter is listing each name (uniquely) per row but the column overall still is returning repeats. What gives? I followed the steps exactly.
@andyfreeman6942
4 жыл бұрын
How can I delete Duplicates from within a Row. Column A Personnel, Column B City, and Column C Country. I have 10,000 records Some have City in Column B and C Wherever there is a duplicate in Columns B+C only display the value of Column B? Any help much appreciated
@mohitverma1465
6 жыл бұрын
Hi there, I’m a subject matter expert on Excel. I’ve a suggestion here when you mentioned that we can’t have the unique list on other worksheet using Advanced Filters. You may go to a new sheet and start applying the Advanced Filter from that blank sheet. Now select the Table range from the sheet where your table lies. Keep copy to another location radio button selected. Finally put the new sheet cell selection in Copy To section and you are good to go. Unique entries will get pasted. I hope this helps. Thanks! :)
@AjayKumar-id7mb
3 жыл бұрын
Thanks Mohit
@moazzamkhan398
2 жыл бұрын
Also we can use unique function instead of advance filter.
@koyenadutta5747
Жыл бұрын
@@moazzamkhan398 can you please give function
@moazzamkhan398
Жыл бұрын
@@koyenadutta5747 =UNIQUE(select the value) that's it.
@kevinrichard5188
3 жыл бұрын
This is an amazing method. It really helped me to get out of a big situation at work. Thanks a lot
@Billyboy91
3 жыл бұрын
YOU HELPED ME ALOT MAN. EASY TOOL USE INSTEAD OF A FORMULA.. THNX A LOT
@globalnature6298
2 жыл бұрын
thank you for advance filter
@foreignreturnvlogs4293
Жыл бұрын
Thanks for upload this video .. very helpful
@ExcelCampus
Жыл бұрын
Glad it was helpful! :)
@kobbymck281
4 жыл бұрын
Thanks sir
@sisirakumara726
3 жыл бұрын
Thanks million really useful at work
@lydiaremick
4 жыл бұрын
Is there a way of easily finding values that are not repeated. So in the case of a list of 1,5,1,7,3,5,7,6, it would only bring back 3 and 6 as they are not repeated.
@koyenadutta5747
Жыл бұрын
how can we do that i different page in excel?
@MohammedFaisal-cr6fo
6 ай бұрын
we can use =unique formula it same ?
@carlobambi9035
3 жыл бұрын
Any idea on how to get categories for eg. Expense category and get its value copied and pasted onto a summarized statement? Please let me know, thanks!
@alishagupta1664
4 жыл бұрын
How can I extract unique product names corresponding to each duplicate values? e.g how can I know what products did a salesperson sell?
@ashishmalhotra4840
4 жыл бұрын
Is there a possibility to list out Unique values in Groups. Example - we can group the Unique values Company-wise (from the video)
@aslammsalam
4 жыл бұрын
Very useful and used it right now. Can you show us how to add year to date such as Mar 27 or Apr 1. I want these dates to convert to DD/MM/YYYY such as 27/03/2019 and 01/04/2019. Thanks
@Kornelka64
2 жыл бұрын
Hi, do you have tutorial for I would like to excel to show me a list of names with value spend more then 0 and ignore anyone with value O or less eg - the list with example below should come back with 3 names only. name value john 0 gary 500 emma 0 peter 0 alice 0 maria 60 steven 10
@macdalinemathye3897
3 жыл бұрын
Thanks for the video
@bridgemontreal
3 жыл бұрын
How to group accounts having same name or numbers with the balances. Thanks
@TeemEastwood
2 жыл бұрын
THANKS FOR THE GREAT VIDEO. IS THERE A WAY TO DO THIS THAT ISN'T AFFECTED BY DIFFERENT CELL COLOURS
@ihuomaobinna5039
3 жыл бұрын
Thank you. Very helpful
@ashikabhat3776
Жыл бұрын
thank you so much
@rinzler6827
2 жыл бұрын
Awesome tip thanks!
@kwemaledbetter323
4 жыл бұрын
Extremely helpful. Thanks.
@aloks_22
Жыл бұрын
This is what i've been looking for! Thanks mate!
@ExcelCampus
Жыл бұрын
Glad I could help. Alok! 😀
@T-Bear
3 жыл бұрын
Tnx. Just what i needed :)
@AllergicToAshAndDust
3 жыл бұрын
This is exactly what I needed! Thank you so much!
@akashrangarej8393
3 жыл бұрын
Thank You sir
@soomrowaseemkhan5317
3 жыл бұрын
Realy knowledable
@kaviyakavi6754
2 жыл бұрын
Hii
@wassup406
Жыл бұрын
Thank you so much I have been struggling to do this and finally you make my problem solve lol that was really exhausting
@ExcelCampus
Жыл бұрын
Glad I could help,@wassup406! ! 😀
@1binaya
3 жыл бұрын
Thanks!
@muhammadafiqtajolariffin5709
4 жыл бұрын
thanks a lot
@lukmanmajid6568
2 жыл бұрын
Thank you Ssebo
@krpuratrafficps6471
4 жыл бұрын
BUT HOW TO CUSTOMER NAME & SALES PERSON WISE EXTRACT DATA.
@LarryPeteet
4 жыл бұрын
Thanks a lot in 2010!
@ranjithrash5329
4 жыл бұрын
Interesting bro. Keep posting such type of videos
@chengwang411
4 жыл бұрын
Bravo 👏
@eyaldavid7532
4 жыл бұрын
Thank you very much Jon! :)
@DaveH3009
6 жыл бұрын
Hi Jon, another possible solution in Excel 2016 would be to use Power Query.
@hiphopers5574
4 жыл бұрын
I want to compare two tables having same unique number and sort the both tables parallel to eachother on the basis of unique number available in both the tables.
@shriefallam8866
3 жыл бұрын
Did it succeed?
@LeandroTrindade-ing
2 жыл бұрын
The command =unique(array,[by_col],[exactly_once]) does the same and updates automatically every time you update your table. I think it's easier, has fewer steps and you can use it on a different sheet.
@stri06
2 жыл бұрын
Yes it is also it's dynamic but the main issue is that you need Excel 365 for Unique in the stand alone or older version is not present.
@LeandroTrindade-ing
2 жыл бұрын
@@stri06 Good observation: I didn't know it, thanks for adding to my comment.
@mansoorali5931
6 жыл бұрын
sir, is there any similar technique, which can be applied in Numbers in Mac?
@payal5366
4 жыл бұрын
With the list I also want to count how many times each value occurred in list
@rajuar1955
6 жыл бұрын
Please make a clear video about financial formulas
@gangadharpavan
4 жыл бұрын
Can't we just remove duplicates instead of having this
@falgunidas603
4 жыл бұрын
No. In some cases you may have all duplicate values as shown in this video. That time removing duplicates means you are removing all your values which is not the solution.
@nzana55
4 жыл бұрын
thanx
@RonWilliams-Hoodle
6 жыл бұрын
Outstanding! This will save me tons of work. Looking forward to learning more. Thanks very much! Ron PS: Am not seeing the link for the macro download. Will head to your website & see if I can find it there. Thanks again.
@krabbypatty6896
4 жыл бұрын
Thanks a lot!
@dreamsfollow8884
5 жыл бұрын
Great thank you ! Werry Helpful
@leviharville6226
6 жыл бұрын
Hi Jon, I have created a very nice dashboard thanks to your very popular Intro to Pivot Tables video. Just like Andy I had a large data set and successfully converted it to several nice dashboards. I have one thing that is hanging me up and it is very annoying. I have created a dashboard with two bar graphs and a 'target' line going straight across it. I added data labels to the data so it was easier to read, but every time I save the file it converts both of my bar graphs to different formatting. It takes away the data labels and it changes the chart with a different type of line for the bar graph. How can I fix this problem? This does not happen to the other 5 dashboard pages I have but it does with this one.
@Budietoyka
6 жыл бұрын
Thank you!
@thesovereignindividual6594
5 жыл бұрын
Does the macro work with the online version of excel, google sheets?
Пікірлер: 94