Computers and Software > Computers and Software - General

What am I doing wrong?

<< < (2/2)

inkman996:

--- Quote from: 3Deep on November 16, 2021, 10:32:38 AM ---My wife is going through the same thing right now with a spread sheet trying to print out on 8.5 x 11 paper and getting half cut off, we hate when people send crap on spread sheets

--- End quote ---

We get them daily, never created to be printed just on screen visual. What I do is start deleting columns and rows not needed, decrease font sizes, squeeze cell widths to remove empty space, and auto wrap everything. Then in print preview you can scale the entire document till it fits on a single sheet.

aauusa:

--- Quote from: inkman996 on November 16, 2021, 11:25:22 AM ---
--- Quote from: aauusa on November 16, 2021, 10:55:30 AM ---looking back at what you are trying to do this is what you need to do.  all names need to be in 1 cell,  then you can make a list of letters on the side for you letter selection and the enter this formula

=LEN(A2)-LEN(SUBSTITUTE(A2,G2,""))    A2 is the cell with all names  g2 is where the letter to be counted is located(off to the side)

--- End quote ---

You are very close but even with your exact formula I am still getting an error. In your example what are you counting?

--- End quote ---

I am counting the letter A in cell A2,  and you designate which letter to count in the last cell in the formula G2.

The formula works here is a screen shot of counting a list of letters for letter A  and C

aauusa:
forgot to mention lower and uppercase matters

inkman996:

--- Quote from: aauusa on November 16, 2021, 11:35:14 AM ---
--- Quote from: inkman996 on November 16, 2021, 11:25:22 AM ---
--- Quote from: aauusa on November 16, 2021, 10:55:30 AM ---looking back at what you are trying to do this is what you need to do.  all names need to be in 1 cell,  then you can make a list of letters on the side for you letter selection and the enter this formula

=LEN(A2)-LEN(SUBSTITUTE(A2,G2,""))    A2 is the cell with all names  g2 is where the letter to be counted is located(off to the side)

--- End quote ---

You are very close but even with your exact formula I am still getting an error. In your example what are you counting?

--- End quote ---



Thanks
I am counting the letter A in cell A2,  and you designate which letter to count in the last cell in the formula G2.

The formula works here is a screen shot of counting a list of letters for letter A  and C

--- End quote ---


Ok my bad, I have figured it out. It was an Open Office issue, for some reason it gives a bracketing error. I redid it on a laptop with Excel and it worked. I was actually right on my first attempt but Open Office fooled me. I like your approach better using the list on the side for easier organization.

Catnhat:
Stahls.com has Number/Character calculators on their website (assuming the number sequences are sequential).  Great for Teams/League type stuff.  (and when your help can't count past 12 for some reason, but that story is for a different time)

https://www.stahls.com/hp-character-calculator

Navigation

[0] Message Index

[*] Previous page