show the find number

1-need the find numbers be show as the result is  show  in A4   V_OUT sheet

2-need show the total columns od data in b1  V_OUT


666666666666666666666666666666666666.PNG8598744458.xlsm
ADRIANA PACCOUNTING ASSISTANTAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Martin LissOlder than dirtCommented:
The workbook that you attached has only 2-digit numbers in the V-OUT sheet. Do you still need the 'Find 3' button?
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin

 Yes  need the 3 finds

Find 1 Find 2  Find 3  be working and show the numbers looking for
0
Martin LissOlder than dirtCommented:
OK then I think this does what you want.
29078859.xlsm
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin

 I try 33 as the look for in find 2

it missed the rigth feedback
0
Martin LissOlder than dirtCommented:
Here's what I get when I try that. Please tell me what cells are wrong and what they should be.Microsoft_Excel.jpg
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
then 43 in find 2

the same inaccurate answer
0
Martin LissOlder than dirtCommented:
Again, when I search for '33' what is wrong?
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin

7777777777777777777777777777.PNG
0
Martin LissOlder than dirtCommented:
I'm confused. Which cells (if any) are inaccurate?
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin

the 33  if not appear in 50 sets  not all columns have an 33 ocurrence

7777777777777777777777777777.PNG
0
Martin LissOlder than dirtCommented:
Try this.
29078859a.xlsm
1

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin This is working as needed

then need capture
to create an history in HIST_DTA sheet

of the selected  i mean to compare ( what  need to be selected )
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin the column count at top
still and not change  as  i cahnge the  look for
0
Martin LissOlder than dirtCommented:
I'm calculating cell B1 as the number of columns that have data. In that case it is 57. If that's not correct then please describe what I should count and what the value should be.
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin  you rigth sorry

i mixed up

you rigth because the total columns of data still the same

never mind ! with  B1 is working great
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
then i will open a new question for the history needed
0
aikimarkCommented:
You might simplify your problem if you change those counts to a =COUNTIF(5:5, $A$4) formula and A6 =Sum(6:6)
1
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Great JOB !
Best Expert !
0
Martin LissOlder than dirtCommented:
Ok then, I corrected the counting of 'Find 2' and I also centered all the numbers in row 6.
29078859b.xlsm
1
aikimarkCommented:
correction: B6, not A6
1
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
aikimark   you are Welcome !!
  thanks for the support  i see it after i closed

but thanks !
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin

is better !
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Applications

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.