Hello
I would like to get from my attahced file how many cell fro column A is contain data
also extract only Number from text in column A with repeat to column F
i already make formula for extraction and two for count but its not correct
Hello
I would like to get from my attahced file how many cell fro column A is contain data
also extract only Number from text in column A with repeat to column F
i already make formula for extraction and two for count but its not correct
Enter in cell G2
Formula:Please Login or Register to view this content.
Enter in Cell F2
Formula:Please Login or Register to view this content.
Last edited by mehmetcik; 07-02-2017 at 04:42 PM.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
Enter in G2 and copy down
Formula:Please Login or Register to view this content.
then enter array formula in F2 and copy down
**Must be entered with Ctrl+Shift+Enter key combination.
Formula:Please Login or Register to view this content.
Last edited by AlKey; 07-02-2017 at 06:16 PM.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Dear Mehmetcik ,Dear Alkey
many thanks for your solution
but i found that the formula that extract number working good but its repeat the number i need to extract number and look if already list in cell above not repeat it again
=countif(a2:a89,"?*")
try this for count
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
F2=IFERROR(INDEX(MID($A$2:$A$89&"- ",SEARCH("-",$A$2)+1,SEARCH(" ",$A$2)-SEARCH("-",$A$2)),MATCH(0,INDEX(COUNTIF($F$1:$F1,MID($A$2:$A$89&"- ",SEARCH("-",$A$2)+1,SEARCH(" ",$A$2)-SEARCH("-",$A$2)))+ISERROR(MID($A$2:$A$89&"- ",SEARCH("-",$A$2)+1,SEARCH(" ",$A$2)-SEARCH("-",$A$2))+0),0),0)),"")
Try this and copy towards down
Hi mazan2010,
I think, and I maybe wrong, but the problem here is that no one really understands what "repeat the number" means. What numbers need to be repeated? Where the formula should be placed? Can you demonstrate what the final outcome should be?
Best regards,
Dear AlKey
As you can see in my attached file in column F with your formula
you will find that the number 24 is repeated 2 times
and 39 is repeated for 7 times
but whta i need as in column G ( conclusion of number present in Column A )
now i found the error in my file many thanks for all
and dear AlKey your formula array is working and nflsales for extraction without repeat
and many thanks for mehmetcik the count formula working good
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks