Excel 相同值对应递增序号

当需要对某一列数据的相同值做标记时,

Excel相同值

在空白列使用公式=COUNTIF(A$1:A1,A1),就可以对应生成递增序号

Excel 相同值对应递增序号

玄机个人博客,Office办公技巧分享。操作分享,资源分享,软件分享,生活分享。

4 comments

israelxclub.co.il

Im excited to discover this web site. I need to to thank you for ones time for this wonderful read!! I definitely savored every bit of it and I have you bookmarked to look at new information in your web site.

zoritoler imol

Admiring the dedication you put into your website and detailed information you present. It’s awesome to come across a blog every once in a while that isn’t the same out of date rehashed information. Excellent read! I’ve bookmarked your site and I’m adding your RSS feeds to my Google account.

detideci1979

No problem, this is a great sports project where you will learn all about sports predictions, bet and win. You will find sports forecasts for any sport, sports forecasts on, basketball, tennis, soccer and sports forecasts on virtual sports. We have everything you need for a good evaluation and analysis. sports forecasts every day.

zoritoler imol

I have recently started a website, the info you provide on this site has helped me tremendously. Thank you for all of your time & work.

发表评论

电子邮件地址不会被公开。 必填项已用*标注