Видео

Brilliant. This totally helped me out! THank you.

Sir, thanks for sharing.very helpful for me. Again thank you very much.

sir, what about comma to column

THANK YOU SO MUCH !!! HUHUHU IT TOOK ME HOURS IN RUclips SEARCHING FOR THIS !!! WTH

Tahnks from BHARAT (India) !

thanks a lot sir

thank you sir for excellent video.

Amazing !!! Great stuff thank you

Thank you so much

I dont understand how this doesnt work for me 😭 All i get are red dots around that cell

Thanks for sharing, my corrective value is not correcting for the total of the remaining days left, is only showing corrective vale only up the next working day and not the whole remaining days?

excellent thank u

excellent, thank you

Thank you very much for this! It was so helpful and saved me a ton of time :)

That's very helpful. How about if we have 2 Call of Duty games in a cell. How can we count the Call of Duty is there twice?

Very helpful, thank you

Why 1/2... I didn't get it

Very useful

easier way: =Concatenate_Range(B2:B23,",")

Hello , Can you help me if cell color based on conditional formatting how we can count by color ?

You’re amazing!!! Thank you so much.

Thanks for sharing

Just reverse process???

THANK YOU. you saved me countless hours of trying to filter WITH - indexes, countif's, large, and rank.eq...... THANKS!

How to list with decimal? For an example to find value for 90.5x90.5 ? Moreover can I get provision for list of value like 100x100 = 10000, but need 100.05x100.05, 100.10x100.10, 100.15x100.15 n so on. Where I can get this data? Any possibility in Excel? Please advise or website

Thank you so much!

Thank bo

mine is not working. Ask to remove the outline. Already remove the borders. Still not function😢

EXCELLENT

Cant count the data of 8.1

Thank you. Related to above, can you please help with this. Please see below data in column A, The desired result are in column B, how can we get the results in column B with formula. Column A required output in Column B Cell A1= Peter Cell B1= Cell A2= John Cell B2= Cell A3= Peter Cell B3= 1 Cell A4= David Cell B4= Cell A5= Peter Cell B5=2 Cell A6= Blank cell Cell B6= Cell A7= Peter Cell B7= Cell A8= John Cell B8= Cell A9= John Cell B9=1 Cell A10= John Cell B10=2 Cell A11= Maria Cell B11= Cell A12= Blank cell Cell B12= Cell A13= Maria Cell B13= Cell A14= Maria Cell B14=1 Cell A15= Peter Cell B15= Cell A16= David Cell B16= Cell A17= Maria Cell B17=2 I have used =SUBSTITUTE((COUNTIF($A$1:A1,A1)-1),0,"") but it works fine only untill first blank cell in column A. In B7 this formula is giving 3, but it should be blank. Basically after every blank in Column A a new set of data develops. The requirement is to serial the duplicates between two blanks in column. Hope this explains the problem. Thank you. Much appreciated.

this is what i looking for, thanks a lot!

Does anyone knows how to make this automated that the result will dinimically changes as we enter or edit the records and / or thier values?

😮

thanks very much! this is super helpful and super easy!

Thanks a lot!!! Are there anyways to convert the final result of this video back to a raw list because I've got a file which already count duplicates however I also needed a raw list too. So I need a way to convert the count duplicate list back to only duplicate list. I hope this question doesn't confused you thankyou

lovely you saved me a day before my acca exam thank you cant be much grateful obliged

Thank you! You saved me so much time :)

Thank you so much!! Exactly what I needed. At first I was trying to count colour cells in a row ,probably my excel is old version or me:)) Thank you so much!!!

Am not able to give the dotted lines and actual is showing until the end date which is incorrect representation

Thank you..

Thank you brother Very informative

Many thanks good sir- this was very helpful.

Here's the quick one, in Cell B type =A1&"," then double click the cell to run down the formula in Cell B. then in Cell C type =concat(B:B). Thanks!

Thank you! just a question.. what if my initial data is from a pivot table?

Great sir thanks

Great To Watch, Thanks For Making

Thank you so much, this really helped :))

this is great, thank you!

Can you use lesser than equal to and greater than equal to in same formulae