Good one! In some cases it is a good idea to use "103" instead of "3" in SUBTOTAL function to ignore manually hidden values.

You are the best, Simple organized and clear. Thanks a lot. Save me time looking for videos on the web

@PKAnExcelExpert

3 жыл бұрын

Thanks for your valuable feedback

great ideas, thanks so much

Thanks a lot buddy! Wonderful learning.

@PKAnExcelExpert

6 жыл бұрын

Thanks for your valuable feedback

অনেক অনেক ধন্যবাদ , খুই উপকার হলো।

Thank you for this amazing idea, how we can do the same to add seq number in Pivot Table, after generating data.

This video made my day thankyou so much

@PKAnExcelExpert

5 жыл бұрын

Thanks for your valuable feedback

Thanks for this amazing trick

@PKAnExcelExpert

5 жыл бұрын

Thanks for your valuable feedback

thanks man best one so far

@PKAnExcelExpert

Жыл бұрын

Thanks for your valuable feedback🙏

Thanks for your video my friend. Can we create a unique ID following the values from first two columns. For example; B2 & C2 have unique values whereas A1 should read and create a unique ID (text&num) and if same values in B2 & C2 are reentered, it should return with same id rather than creating a new ID

Brother you solved my problem thank you.😀

@PKAnExcelExpert

2 жыл бұрын

Most welcome

Hi I have a question, Is there any way to automate this formula rather than dragging or copying the formula to different cells ?. Is there any macro we can automate this task and allow user to enter data from second column directly ? Kind Regards, Mukund

Are this formula work in arrayformula?

Thank You

I want same dynamically serial no. In advance filter on another sheet is it possible?? Plz reply

Thanks sir you are here of excel

@PKAnExcelExpert

4 жыл бұрын

Thanks for your valuable feedback

Really awesome trick

@PKAnExcelExpert

3 жыл бұрын

Thanks for your valuable feedback

Always useful, thanks.

@PKAnExcelExpert

6 жыл бұрын

Thanks for watching and sharing your valuable feedback

@rraushan2088

6 жыл бұрын

Thanks really it’s too much useful me.....thanks again...!!

@PKAnExcelExpert

6 жыл бұрын

Thanks for watching and sharing your valuable feedback

=IF(C2="","",SUBTOTAL(3,$C$2:C2)) this formula doesn't work online on MS Teams, as "serial number", it goes to 0000 and then 11111 and then 22222 and so on... is it possible to shed some light how to solve this issue with online excel spreadsheet, please? All I need is a column with serial numbers on my online (MS Teams) excel spreadsheet, which works even after "filtering" the data.

Superb boss tnx

@PKAnExcelExpert

6 жыл бұрын

Thanks for watching and sharing your valuable feedback

Dear Respected sir your voice is very sweet 😋

@PKAnExcelExpert

Жыл бұрын

Thanks🙏

Greate Logic sir

@PKAnExcelExpert

6 жыл бұрын

Thanks for watching

Sir, Having learnt from your video I applied the function to create dynamic serial number, so a big thank you for you. But sorry to say that, when I copied the data to sheet no 2 it didn't work. Would you mind to help me in this regard by providing your Email id which enable me to send the excel file to you for necessary correction.

Great trick sir

@PKAnExcelExpert

3 жыл бұрын

Thanks for your valuable feedback

Thank you sir

@PKAnExcelExpert

5 жыл бұрын

Thanks for watching

Thanks sir.

@PKAnExcelExpert

3 жыл бұрын

Welcome

It is good .regarding this sheet I want automatically serial number also pls help me

Wawawawaoooooooo excellent job

@PKAnExcelExpert

3 жыл бұрын

Thanks for your valuable feedback

@ibrarshah5187

3 жыл бұрын

Thank you sir, I am job in pak army i have few office problems can you help me on those.

Sir thanks it's work in a normal table, but not work when I make "Format as Table" from Home Menu, Please advice.

If data is zero by formula in data cell then how to use this formula to not count this row in serial

Sir apane jo uper heding mai series no and Emp id ,or puri line stop hai or ap baki niceka sara deta scroll karke dekh sakato ho toh oh heding stop kaise karate hai?

Hi i tried this formula but starting number 2.. could you pls help

@PKAnExcelExpert

6 жыл бұрын

Hi Ramesh, I have given the download link in video's discretion box. Please download this excel file from there for better understanding.

Bahut badhiya

@PKAnExcelExpert

6 жыл бұрын

Thanks for your valuable feedback

@nitinsingh.2107

6 жыл бұрын

is formulae ko main data mein laga ke agar filter karte hain to result aata hai. But agar pivot se data fetch karte hain to serial wise nahi aata.

how to auto generate this series 2051/21 next 2052/21 and 2053/21

Its not working when I enter any other data in row, it should show the number automatically

⭐⭐⭐⭐⭐

@PKAnExcelExpert

2 жыл бұрын

Thanks🙏

I have a doubt...

ctrl+ shift+L dosn't work

How to create a series starts from 1, 1.1, 1.2 to 1.10, 1.11, 1.12, 1.13, 1.14 to 1.100?

@ManojKumar-qr8wx

2 жыл бұрын

Add 0.10 in 1 and so on

@iq2823

2 жыл бұрын

@@ManojKumar-qr8wx I did it but it doesn't continue the series. All the time we have to add 0.1+1 in our series and it becomes manual not auto. For example: 1+0.10 = 1.10 and 1+0.11 = 1.11 and 1+0.12 = 1.12 but all the time I have to change value manually. It doesn't work. Could you please share some other ideas / logics?