Комментарии:
Can you do this for bank recs
ОтветитьExcellent, Good stuff 🎉🎉🎉
ОтветитьExcellent! Really useful! Thanks
ОтветитьChester - excellent stuff. thanks for sharing! Question, how would you recommend handling comparison of a master sheet and a data sheet which has a different number of rows and only comparing certain columns?
ОтветитьI hav one question, how to check difference between 2 columns where one is giving name with legal form and another column without legal form
ОтветитьHello Chester, I watch most of your videos and have found it very helpful. I have a question, What to do in order to avoid the 0.01 cent difference between excel and calculator machine, example a total sum of few amount are either more or less that the calculator? Thanks,
ОтветитьQQ - how would you approach this if the data in the two versions are not in the same order and also if one version has more rows than the other (i.e. A sales report where opportunities are added and removed week over week and we want to track and flag the movement of changes to dates, revenue and also net new or net closed opportunities).
ОтветитьUseful thanks
Ответить👍
ОтветитьThanks. There are 2 spreadsheets. Bigger spreadsheet containing small spreadsheet data. How to find the different rows in bigger spreadsheet?
ОтветитьThank you Chester for your great tutorial. Is there any way to 1- conditional the duplicates in 2 different sheets with different headings (Only Item # is the similar in the headings of these 2 sheets?) 2-copy the duplicates records to the seperate sheet? Ex: Sheet 1 has heading Item # in cell A1, B1 = Description1, C1 = Price , etc...Sheet 2 has heading including Item #, Shipping Method, Payment Type, Destination, etc.......thank you so much Chester. Liked and subscribed !
ОтветитьThanks for your efforts here. 'Use a formula to determine which cells to format' option is missing, does anyone have any advice? The window that pops up is tiny and basic compared to yours. Excel Version 16.72 for Mac.
ОтветитьIs it the same in mac ?
ОтветитьI am very frustrated. This worked but only once. Its not a refresh issue. Let me explain. I have one WB with two sheets. One has a list of names that have done business with us. The other is a list for that month and there are NEW partners that have not done business with us. I jsut want to automatically highlight the new partners. I followed this but it only partially worked. Upon initial copy and paste of names but If I go and add a name after that it stays highlighted even if it is on the YTD list. Can you help me? I can send you the WB if need be.
Ответитьplease i have an issue this please report the prblm dear admin .I want to compare two different worksheets containing a list
Ответитьbro you save me! thanks !
ОтветитьHow to highlight the data with Visual Basic
ОтветитьDoes anyone know how to do this in the Online version of Excel? The online version does not let me do the same thing as this.
ОтветитьI love this tutorial. I have to up the game a little though, I need to compare multiple sheets of contact lists, 6 to be exact. What changes do I need to do in the formula, if any, to compare all 6?
ОтветитьGreat video i find it very helpful
ОтветитьHi Chester i got this error "You may not use references to other workbooks for conditional formattung critieria"
ОтветитьReally helpful. Thank you.
ОтветитьThank you very much for the video! However, I notice that the date format has changed into numbers after the quotation, could you tell us how to convert it back to the format of date? Thank you for your attention.
Ответитьyou saved me 8 hours worth of work
Ответитьexceptional video. Thanks. Hugs.
ОтветитьGreat, fast, simple...
ОтветитьThanks! Very useful 👌
ОтветитьThank you very helpful
ОтветитьFantastic compares and so well explained.
Thank you!
Thank you, the video is so helpful and easy to follow. Subscribed to your channel right away.
ОтветитьIt is just what I need. Thank you very much!
ОтветитьI keep getting the following message " "You may not use references to other worksheets or workbooks for Conditional Formatting criteria"
ОтветитьI have a question! I have two worksheets. one work sheet consists of CustomerName in one column and Income in another column. The second sheet consists of CustomerName in one column and email in another column. The sheet with customername and income has been filtered to provide the customers I am interested in and now I want the sheet with the customername and email to be filtered to only show the customers that I have on the customer and income sheet. How do I do this?! Thank you so much in advance for any help
ОтветитьVery helpful. Thank you. I wonder if there is a method to compare 2 excel tables when the rows are mixed, not at the same order?
ОтветитьIn my case, Both excel does not contain all the ids. What should be the formula for that?
ОтветитьThank you for that great video!
ОтветитьHave a large list of vendors, titles, salaries and such and I receive a "new updated version could have new people added or name changes and need a Formula to "Compare" the new one with the old and see where those changes are made.If I need to Copy and Paste the new one on a Worksheet in one Workbook or from a new Workbook?
ОтветитьGreat video. Really helpful. Thanks!! How would you compare them if lines in the sheet were deleted on a newer version? Only asking because, once a line has been deleted it highlights them all from below that point.
ОтветитьWhat if V2 has new values, that V1 doesnt. How can you be able to show select them?
ОтветитьThank you. This was very helpful.
ОтветитьWhat is the best way to compare columns of data across 2 sheets in the same workbook. If any data from sheet 2 column C shows in sheet 1, column AV - highlight green. If no values match, highlight red.
ОтветитьWhat if I want to compare to lines but the order is messed up? Or if I want to check for extra contents and lines?
ОтветитьHow can you handle two sheets were the data location is not identical? Where sheets Ver1 and or Ver2 have rows the other does not?
ОтветитьDoes it compare different sheets
One longer than the other
Thank you!!!
Ответитьwhat should we do if the datasets are diferent in size
ОтветитьThank you - that was a great timesaver and made an impossible task a breeze.
ОтветитьHey nice work! Also, what was that music you played in the background, that was relaxing
Ответить