Nice video sir. Great job explaining and giving the extra tips along the way !

@DougHExcel

3 жыл бұрын

Glad you liked it

Thanks, Doug that's what I was looking for!

@DougHExcel

2 жыл бұрын

Glad I could help!

This was amazing Doug!! Subscribed immediately! Problem solved!

@DougHExcel

4 ай бұрын

Thanks for the sub!

Great tip, Doug.

@DougHExcel

6 жыл бұрын

Hi Randy Smith, thanks for the comment!

Thanks buddy! Your video still rocks!!

@DougHExcel

2 жыл бұрын

Thanks! You rock!

Thank you so much for your tutorial!

@DougHExcel

2 жыл бұрын

You’re welcome!

Thats exactly what i needed today! Thanks

@DougHExcel

2 жыл бұрын

You’re welcome!!

@FRANKWHITE1996

2 жыл бұрын

@@DougHExcel Thanks again! 🙌🔥🙏

Thanks!

@DougHExcel

4 жыл бұрын

You’re welcome!

Thank you❤

@DougHExcel

5 ай бұрын

You're welcome 😊

Thank you sir

@DougHExcel

7 ай бұрын

Welcome!

Thanks

@DougHExcel

5 жыл бұрын

You’re welcome!

Hi Dough! If I wanted to flag the duplicates in Power Query. Say a calculated column, the first line would have a 1 and all duplicates below it should show a 0. Is this possible in PQ?

@DougHExcel

7 жыл бұрын

This vid might give some insights kzread.info/dash/bejne/gmWD3K2Qh7rWhrw.html

Hi DougThanks for this video. How can I not only identify duplicate but remove them using power query. I was trying to use COUNTIF function to label first occurrence as 0 and other will follow as 1,2,3...Is there a power query formula to the duplicate in number of occurrence the way countif fn will count them in excel sheet. Thanks

@olaayorinde6865

7 жыл бұрын

Thank you Doug, pls can you paste this link again because there were no video in the above link you pasted.

@DougHExcel

7 жыл бұрын

Try this.. kzread.info/dash/bejne/gmWD3K2Qh7rWhrw.html

@olaayorinde6865

7 жыл бұрын

Thanks

This was really nice. Can I split this workbook into 2 worksheets with PowerQuery? One with Duplicates and the other No Duplicates? Thanks

@DougHExcel

3 жыл бұрын

Yes you can. Just reference the first one you created and make that the duplicate or non duplicate query (diff name) and load to sheet.

@shoppersdream

3 жыл бұрын

@@DougHExcel Thank You!

Can it be done for multiple columns, I'd be working with sales files where one column will always have duplicates such as invoice numbers. I wouldn't be removing those. I would like to remove a row of 20 columns where the entire row is an obvious duplicate that must be removed.

@DougHExcel

3 жыл бұрын

Yep, it can

How to compare two big excel files by power query? Sheet1.xls and Sheet2.xls Both haveThousand rows and more than 50 columns each . they have complete different columns unless 2 coluns C end D are common in both. .I want to have sheet 3 with all lines and coluns of sheet1 except all lines( when the line C and D lines) matchs sheet 2 ? Pls. Basically i want extract the difference Thanks

@DougHExcel

5 жыл бұрын

Maybe this one will give some insight kzread.info/dash/bejne/eaCBqKSHgbi3gZs.html

hi Doug, if I want cell a2 change it's cell color, every time cell a1, shows the word N/A. what formula would I need to use ? thank you. dan

@DougHExcel

8 жыл бұрын

I'm Assuming you are using the conditional formatting feature (kzread.info/dash/bejne/n5mjydF6j7C-nco.html). You could use the errors to define the conditional format if you meant #N/A. That is an error condition that you can define a conditional format. If it is just N/A, use the condition criteria in quotes (i.e., text equals "N/A")

@wadieseruge3523

8 жыл бұрын

Doug, Hi. Im not sure if i explained my self correctly. Here is what im trying to do, is the following: When cell A-1 shows the word "split-shift", i would like the cell below that, that is A-2, and A-3 to change its cell color to the word "open". Which part of the conditional format option/function would you recommend me to try, to make this work. Thank you. Thank you for the fast respond earlier. Dan

How to do look up in power query for large data sir.. Data exceeded excel maximum limit

@DougHExcel

7 ай бұрын

Try to use CSV file as your source. However the output tab will have the constraint.

how to find partial duplicate in power query

@DougHExcel

3 жыл бұрын

maybe one of these related can give insight kzread.info/dash/bejne/mK6asJptm6fXl7g.html

@ManishKumar-qj7sq

3 жыл бұрын

@@DougHExcelthanks..bt this is not what I want..

Why not just go to "Keep Rows" > "Keep Duplicates" - to identify them... Easy peasy. Then you can always X out the step it creates after identifying them.