LinkBack URL
About LinkBacks
hello guys,
im having a trouble doing this formula because my excel app lags due to it.
see attached file for the detail.. column G is where i put the formula.
Equating a new formula to a same formula with fast result
hello guys,
im having a trouble doing this formula because my excel app lags due to it.
see attached file for the detail.. column G is where i put the formula.
If you can sort the data and use a helper column then try:
- Sort columns A:D by column A then by column D
- Insert column between current columns D and E.
- In your new E2 enter formula:
=IF(AND(A2=A3,D2=D3),"",A2&"_"&D2)
copied down all the way.
- Now your formula in new H2 is =COUNTIF(E:E,"*"&F2) copied down.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
HI i tried it but doesnt work,,Originally Posted by NBVC
can u make it to the attachment?
See attached.
Remember you must sort columns A:D in ascending order first by column A then by column B.
Hi is their any other way i can drag and copy a formula because my column is too long
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks