LinkBack URL
About LinkBacks
Hi,
I need a formula or function to display the cpounter in next column "Expected Answer" against claim status.
Can anyone help?
PFA excel sheet for your reference.
Hi,
I need a formula or function to display the cpounter in next column "Expected Answer" against claim status.
Can anyone help?
PFA excel sheet for your reference.
welcome to the forum, PrashantS87. try this in B2 & copy down
=COUNTIF(A$2:A2,A2)
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
I take it you would like the number to update to +1 of previous count (Column B) against what is selected / typed in to Claim Status (column A)?
A countif function in column B should suffice, place the following in B2 and copy down:
If I have misunderstood your query, please let me know
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks