Free Microsoft Excel 2013 Quick Reference

I am using numbers as a way of referencing data to a category.

e.g. below, Alison, Emma and Peter all belong to one family, with the code 1.

Parent FChild MChild Family code

Alison________________1

_____ Emma__________1

____________Peter____1

David

_____Elena___________2

_____Lisa____________2

I need to count the number of families, and therefore wondered if there was a function to count the number of different values in a column, so in this case the result would be two because there are two different values.

many thanks,

maharg

e.g. below, Alison, Emma and Peter all belong to one family, with the code 1.

Parent FChild MChild Family code

Alison________________1

_____ Emma__________1

____________Peter____1

David

_____Elena___________2

_____Lisa____________2

I need to count the number of families, and therefore wondered if there was a function to count the number of different values in a column, so in this case the result would be two because there are two different values.

many thanks,

maharg

- Number Of Rows With Data In A Column
- Count number of rows with data in a column....
- How do you count number of characters in a single cell
- Counting number of times x appears in a column
- Count number of non-blank cells in a range
- Count number of cells and total in one column, based on another column suffix
- Counting number of times a Text pattern appeared in a range
- Counting the Total number of Rows containing data
- Macro for counting number of non-zero items in a column
- Need to Organize by Number of Times Value appears in a Column
- A formula that uses the last piece of valid data in a column
- Count the number of times 1 happened in a row
- How do I count the # of unique occurences of a text in a column?
- Determining the number of cells with data in a column
- Count the number of times 1 happened in a row
- Reversing Order Of Data In A Column
- Calculate number of rows with data
- Total number of things (Eg:word) in a column
- Location of the Last cell in a column containing data
- Copying a range of data in a column and pasting to another sheet
- Graph all data in a column
- Count number of consecutive blank cells using script
- Finding last cell with data in a column
- Replace data in a column

Date

12/2

11/3

10/2

11/4

here DATE is the column heading

and here number of rows with data is 4

HOW to get it from VBA statements

Also I need to add up all the data and have the total in the next free cell in column - A, and the number '50' in the matching cell in column - B.

Every time the report is run the number of cells used could/will change.

I have attached a example of what I need to end up with.......

What formula can I put in Col B?

So that it counts the number of times the item in Col A has appeared.

Data cannot be sorted and preferably not a CPU intensive formula as its going to be put into a 15,000 row spreadsheet

Thanks

I want to count the number of non-blank cells in a range from A to Z along a given row.

Then once the loop is done i want it to tell me the row which had the most non-empty cells but its not working.

I have data in columns D through H some values(numbers).

I'd like to do two things:

Obtain the number of cells that are in each column that have a

corresponding value that ends with a =T in column C.

Also, obtain the total of the values of the cells in each column, also

of which have a corresponding value that ends =T in column C

Tried messing with sumproduct, but haven't hit on the right formula.

TIA for thoughts.

Pierre

Hope all fine

Suppose i have a range A1:A13 and it is filled with data. suppose the data is as below.

Fun

Funny

Hunny

Sunny

Fun

Funny

Hunny

Sunny

Fun

Funny

Now i want to count number of times "un" appeared in this column A.

how can i do it using excel formula ?

I need to count the number of rows containing data in a worksheet and then hold this data in a string called countrow, very simple but cant quite work it.

Thanks

for example:

B6:

1

2

3

4

5

6

And then n would equal 6

What I need though is a way to organize the data in a different manner. I only need the usernames that have been logged multipule times to display, or be separated from those that only appear once.

If I can seperate the usernames that appear two or more times from those that only appear once

I would like to be able to sort by the number of times that the username repeats in the sheet. (i.e) Usernames that have appeard 5 times by alpha at the top followed by 4 ect. This would allow me to eliminate those that only appear once easily and allow me to work with the data I need.

If there is a way to organize the usernames by alpha, but keep those that have not appeared multiple times from displaying, that would be fine as well.

Here is essentially what I have now. The Usernames are sorted by Alpha

Line1: _UsernameA__Info__Info__Info

Line2: _UsernameB__Info__Info__Info

Line3: _UsernameB__Info__Info__Info

Line4: _UsernameC__Info__Info__Info

Line5: _UsernameD__Info__Info__Info

Line6: _UsernameE__Info__Info__Info

Line7: _UsernameE__Info__Info__Info

I need UsernameB and E separated, I can't do it manually, because I have thousands of lines of this, and a low percentage are repeat Usernames.

Ideally it would look either like this:

Line1: _UsernameB__Info__Info__Info

Line2: _UsernameB__Info__Info__Info

Line3: _UsernameE__Info__Info__Info

Line4: _UsernameE__Info__Info__Info

With the other data hidden or Like this.:

Line1: _UsernameB__Info__Info__Info

Line2: _UsernameB__Info__Info__Info

Line3: _UsernameE__Info__Info__Info

Line4: _UsernameE__Info__Info__Info

Line5: _UsernameA__Info__Info__Info

Line6: _UsernameC__Info__Info__Info

Line7: _UsernameD__Info__Info__Info

I know I've seen data organized in this manner before, I just need a way to do it. Any Help is greatly appreciated.

I know various ways to find the reference of the cell that has the last piece of valid data in a column, but I don't know how to then include that in a formula. Let me provide an example.

Column A is Date

Column B is a stock price

Column C is another stock price

I want to create a formula that gives me the percent difference between the FIRST date in my data and the last date in the data. I'm currently using:

=B35/B3-1

=C35/C3-1

Then after today's stock prices are entered in the sheet I'll change it to 36, then the next day 37.

How do I use something like the MATCH or ADDRESS command and incorporate it into this formula?

times 1 happened in a row starting from a certain date.

For example, from A1 I have 1,1,1,0,0,1,1,1,1,0,0 - I would like to get the

answer of 3 (as starting from A1 I have 3 "1s" in a row, the rest of the

numbers aren't relevant). The max I want to be able to get is 11.

--

Thanks!

Stephen

number of unique text entries in a column.

I have a column ("A") of data on a sheet ("OldFiles") and I just need to

know how many cells are in that column have data in them. The column is

sorted, so the non-blank cells will be contiguous and will be at the top of

the column.

TIA,

Ken

times 1 happened in a row starting from a certain date.

For example, from A1 I have 1,1,1,0,0,1,1,1,1,0,0 - I would like to get the

answer of 3 (as starting from A1 I have 3 "1s" in a row, the rest of the

numbers aren't relevant). The max I want to be able to get is 11.

--

Thanks!

Stephen

2

3

6

7

But I would like to reverse the order to:

7

6

3

2

Any help would be much appreciated. I've attached a workbook just in case. Thanks.

whether the number of rows filled (of column A) with data is 3 or more.

msg hello is printed.

is this syntax correct?

Code:

If workbook2.Sheets("Sheet1").CountA(A) = 3 Then Msgbox "Hello"

column. For example if 'Strawberry' is written in column 'J' 10 times, I want

to have a seperate page that shows that information.

that contains data. The location will always change as more data is added to

the sheet.

I am trying to set up a macro to graph all data in a column.

The spreadsheet will be used on numerous projects with varying amounts of data. Therefore I need to get the code to select all data in the column, then produce a graph and have this code be flexible enough to work on different amounts of data.

Can anyone help.......please!!!!!

I am new to Excel. Please help me with the below problem:

I want to write a script which will count the number of consecutive blank cells in a column. for eg: Assume A1 contains "one" and A5 contains "five". the cells in between A1 and A5 are empty. i want to get a count of the number of blank cells in between A1 and A5, using script. Is there any way i could achieve this?

Regards,

Anu

data in a column, here is what I want to do

the function I have is

=if(a1=0,0,(b1-$cS10)*d1)

C10 is the total for that column

now that works fine on sheet 1 but on sheet 2 and then

sheet the total is in cell C23, due to the nature of the

spreadsheets I am coding it so the formulas get entered

each time by clicking a button. How do I find the last

cell containing data in column C and then use it in the

formula. Once I can find it on one sheet then I can find

it on the rest

Thanks

leave any other text there. I think the whole column is formatted as TEXT so

I may be running into a problem there. Will I still be able to create some

sort of formula

If data >1 or <10 then replace with " "

--

Thanks

No luck finding an answer? You could always try Google.