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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
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?
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin

 Yes  need the 3 finds

Find 1 Find 2  Find 3  be working and show the numbers looking for
Martin LissOlder than dirtCommented:
OK then I think this does what you want.
29078859.xlsm
Acronis True Image 2019 just released!

Create a reliable backup. Make sure you always have dependable copies of your data so you can restore your entire system or individual files.

ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin

 I try 33 as the look for in find 2

it missed the rigth feedback
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
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
then 43 in find 2

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

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

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

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

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 )
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin the column count at top
still and not change  as  i cahnge the  look for
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.
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
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
then i will open a new question for the history needed
aikimarkCommented:
You might simplify your problem if you change those counts to a =COUNTIF(5:5, $A$4) formula and A6 =Sum(6:6)
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Great JOB !
Best Expert !
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
aikimarkCommented:
correction: B6, not A6
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
aikimark   you are Welcome !!
  thanks for the support  i see it after i closed

but thanks !
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin

is better !
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.