# Keeping Track Of How Many Times A Number Shows Up

Apr 22, 2009

Say, for example, I have a spreadsheet as follows:

0 1 1 2 3 2 0 1 2
1 2 1 2 3 3 1 0 1

Is there a way to count the number of times a specific number shows up and have excel post it to a different cell? I need to know how many times a certain number came up for a specific row, and how many times.

## Counting Number Of Times TA Shows Within Strings Of Text In A Range Within Sheet?

Dec 7, 2011

How would I go about counting the number of times TA shows within strings of text in a range within a sheet. Example: TA,MH in cell A2, CB,TA in cell C40, ES,TA in cell Q19. Result would be 3. Ideally, I'd like the formula to reference a cell that has TA as the look up data such as in A1 I'd have TA.

## Keeping Track Of Payments

Apr 24, 2009

i am a builder and i want to make a spread sheet to keep track of what i have been paid and the labour costs i have paid out

so i am working on 20 houses that all have 7 stages of payment each, and 5 to 8 men working on them who receive a price for each stage, but are paid a portion of that price each week while they are working on that stage

what i am trying to do is set up a sheet to keep track of what has been paid and the balance remaining for each stage and what has been received

i have tried doing it a few different ways but im none to clever with spread sheets and what is causing me the problem is next to each payment made i need to put the date and the name of the person who was paid so it always seems to just look a cluttered mess

have any of you got any ideas of how i could simplify this and make it look neat and easy

or alternatively is there some other software that may suit this application better?

## VBA Functions - Multiple Inputs And Keeping Track Of Them

Sep 17, 2013

I have several formulas that I use over and over, so I'm creating VBA functions that I can call from a worksheet.

But...when I have multiple inputs going into a function, is there a way to remind the user which input comes next in the same way that Excel does with built-in functions?

For example, when you type in =PMT( Excel brings up the helper text so you know that the order of inputs is (rate, nper, pv, etc....

Is there a way to bring up that same helper text in my own function? So if I have up, down, right, left as inputs and give the spreadsheet to someone else, they can see it's up, down, right left and not right, left, up, down .

## Appropriate Template/worksheet Needed For Keeping Track Of Turnover

Jan 5, 2009

I'm trying to find a simple Excel template to add my sales invoices together for a year...just so I know what I've earnt...nothing complicated.

The Columns I need are;

date - invoice no. - customer - labour - materials - total

I'd like it to add together labour and materials to the total box ( or just labour in the total box if no materials for that job.)

Then each invoice adding up as I add more with subtotal of labour and materials then a grand total.

## Linking 3 Sheets To Summary Sheet Keeping Track And Totals Of Categories

Jul 22, 2014

I have a spread sheet for my checking accounts. There are 3 sheets, BW, QW, and Chase CC. In the 1st 2 sheets row D is named "Category" and the 3rd sheet has the same name but is in column C.

How to link the 3 sheets to a summary sheet keeping track and totals of the categories ?

Example in sheet BW I have a category called "Utilities" and the column to the right of that is the amount. Then ect for other categories.

## Keeping Track Of Scores And Automatically Displays Names Of Players In Descending Order?

Feb 7, 2012

I'm fairly new to using excel and have been trying to create a simple spreadsheet that keeps track of scores and automatically displays the names of the players in descending order. Anyway I have gotten to the point of using hookup to match a value and return that players name. But when two players have the same score it will only return the first found value. I sort the number scores using a LARGE function and it works great. Then I use something like this =HLOOKUP(Y2,B27:K28,2,FALSE) to match that value with the players name. How to return the other players name when the scores are the same?

## Keeping Track Of Data Over Time Even If The Data Is No Longer Visible?

May 20, 2013

I work in a medical facility, and I need to track data I've entered representing patient visits indefinitely over time. I've attached a weekly grid to this thread that I use to record which patients have had visits during the course of the week. It sums their total visits on the right. I need to continually track these because every patient gets an insurance-mandated progress update after 10 visits. Unfortunately, they don't always show up, and the most I can possibly keep track of is two weeks, max, and most patients only get two visits per week. Is there a way to dump these sums into another column indefinitely?

## Keeping Track Of Which Macro Is In Which Module Since You Can't Rename The Module?

Mar 27, 2009

After all the awesome macros I've obtained with the help of all of you, I now have over 30 macros, each in its own module. I have tried without success to re-name the modules with no luck. How is everyone organizing these?

## Counting # Of Times An Item Shows Up In A Table

Dec 17, 2005

Is there a way to select a table and have excel produce a list ranking the #
of times each item shows up in the list, i.e.

dog 5
cat 2
bird 1
?

## Building Sheet To Track Delivery Times Of Wagons On Daily Basis?

Mar 23, 2013

I am trying to build a sheet to track deliveries into the company I work for.

We book loads to come in at set times for production, I am wanting a sheet which I can enter the due time and the actual time of the the different companies and then produce a report in graph format to see which are the worst at late or early deliveries.

## Format Cells So Number Shows As Number Over Zero

Jan 21, 2008

how do you place 100/0 so the /0 stays static and the 100 can be used to operate? (ie: 100/00, 101/00, etc)

## Keeping A Number Positive.

Sep 22, 2008

In a basic formula, I need to take one number from another. But I need to keep the answer to zero, not a negative number.

## Keeping Two Digit Number When It Is 1-9

Aug 19, 2014

I have the following

[Code] .....

AK5 value will be 2 - 21.

I need it to display

A1D05

or

A1D21

or whatever the number is after A1D, but when AK8 = a value of 1 or 2 or 3...... It comes back as A1D1 or A1D2... How ca I keep the two digits in AK8 to stay and put the value the way I want in AE5 ...

## Track Number Between Two Tabs On Same Workbook

Mar 18, 2009

I'm trying to see if the same numbers exists in two different spreasheets on the same workbook. Both "asset tags" columns are sorted ascending. If the number appears on both table I would like my formula to add a "Y" (for yes) on the proper cell. Not sure if I should use Vlookup, sumproduct or sumif formula. Here is the main table where I want that "Y" to appear in Column D .....

## Track The Number Of People From Each Zip Code

Jun 28, 2009

I have a workbook with a sheet for each day of the month where guest information is entered. There is a column for each item. There is a summary sheet that summarizes the number of members, guests etc. One thing I would like to track is the number of people from ech zip code.

## Track Number Of Occurrences During Particular Time Range?

Jun 15, 2014

I have a data with phone number, date and time.I want to track how many number of calls came on a particular date and during a particular time. formula which would work in excel and track the same.

## Formula - (-) Shows Up And Ranks This As The Number One

Mar 16, 2007

On cell K7, i have this formula:

=IF(ISERROR(I7-J7),"",I7-J7)

On cell L7 i have this formula:

=IF(ISERROR(RANK(K7,\$K\$7:\$K\$29,0)),"",(RANK(K7,\$K\$7:\$K\$29,0)))

The issue is that in cell K7 a dash (-) shows up and ranks this as the number one, even when i have no data in I7 and J7.

MTD Conv
Conv Goal
B/W Goal
RK
-
1

29.3
31
(1.70)
12

21.8
25.0
(3.20)
15

## How To Stop Recalculation When Cell Shows Certain Number

Jul 7, 2012

I have this sheet full of random data and I want to recalculate extra fast so I keep my finger on F9 which causes the random data to randomize really fast of course. Now, in B1:AT1 I have numbers that change with every recalculation but here is the problem. I want the recalculation to stop when excel identifies a zero in that range which doesn't happen often.

## Chart In Spreadsheet That Shows Number Of Claims Per Defect

Dec 31, 2006

I have a chart in my spreadsheet that shows number of claims per defect. Is there a way to format this bar chart so that it will only show the top 5 automatically, even when they are constantly changing? There are a total of 13 different catagories.

## Copying Information From Table But Only Number Shows Up Not Actual Formula?

Aug 13, 2013

I am trying to track inventory over 160 days in a spreadsheet. Every week I update a table that shows the number of skus and dollar amount that are over 160 days in a table. I have a ton of formulas that will automatically populate once I put in the new weekly data on a different spreadsheet. I want to track the weekly data so what I would really like to be able to do is paste the actual numbers and not the formulas into another excel spreadsheet so I can track the progress over time. Is there a way to just paste the actual numerical number instead of the formula itself?

## Reference Cells Keeping Columns The Same But Change Row Number Based On User Input

Dec 10, 2012

Date
#
Lname
Fname

[Code].....

With that said, I want to put the row number of a user in (I have a few thousand on this spreadsheet, and all the = data be automatically pulled based on the row number I put in cell B1. So I'm hoping to write in cell B1 the following - "143" (without the quotes), and the remaining cells in column B automatically pull that data based on that, so it would look like the following

Row #
143
Name:
=C143&" , "&D143&" "&E143

[Code]....

How do I write the functions to keep the columns the same, but change the row number based on the number I input?

## Textbox That Shows Current Record Number Or Listbox To Show All Records

Apr 14, 2013

I am looking for a text box code that works with a search userform.

Basically, I search using my userform find function and if there are more than one record found I want to be able to either:

1) have the records found appear in a listbox
0r
2) have the first record appear in the userform but a text box will show I am on 1 of X records and when I click a command button, go the next record, which will be 2 of x records and so on...

VB:

Private Sub cmbNext_Click() Dim FirstCl As Range
'first data Entry
Set FirstCl = Range("a2").End(xlDown).Offset(1, 0)

[Code] ....

This is the code for the button that goes to the next record but I am unsure how to relate that a listbox or text box that shows the record number I am on out of the total that there are.

I would also be looking for another button that goes back one record. So i am hoping it's as easy as reversing the code for the next record function.

I am not sure if the listbox that could show all I records and one can just be selected is easier than showing the textbox with the " 1 of X records".

## Macro Of Formula That Shows Character Location Number Of Text File

Aug 14, 2014

I am looking for a way to show the character location number of a text file, possibly in the first row or a macro that I can run at any given location that will give me the location # I am currently viewing.

Currently, when I open the file I can see the character # at the opening screen (see attached file) but they disappear when it actually converts. I would like to be able to keep the character location ruler once the file is opened in Excel so I don't have to manually count.

## Countif To Find Number Of Unique Values And Number Of Times Repeats Happen

Aug 20, 2013

I have a large amount of data and I'm trying to count how many unique values I have in one column. I also want to know how many times each duplicate appears. I tried using a pivot table but it's not working for me.

I also tried the following formula: =SUM(IF(FREQUENCY(H:H,H:H)>0,1)) but it's not quite working.

## Generate Text Value Based On Number Of Times ID Number Previously Appeared?

Aug 3, 2012

Is there a function that allows you to read column A for an ID (these may or may not include letters/numbers/"?", are non-sequential and are of variable lengths) and, if it is the first time that it has seen an ID column B will read "sample_1_arm_1", if its the second time it has seen an id it will read "sample_2_arm_1", etc? An example of what I am trying to do on a much larger scale:

id
event_name
C83-858
sample_1_arm_1

[Code].....

## VBA - Copying And Pasting Unknown Number Of Values Each Different Number Of Times

May 28, 2014

I am trying to come up with a macro that selects values from one sheet and inserts them into another sheet. The number of values will change each time based on the user's entry, as well as the number of times that each entry should be pasted.

For example:

Entry: X | Y | Z
Number of Times to be Inserted to New Sheet 3 | 2 | 1

Result:
X X X Y Y Z

I have spent a while trying to figure it out, however the best I can come up with is using an array, but I can only get one value from the array to paste multiple times:

(*Note: In my testing, I didn't insert into new sheet or set up the array to handle different values, I was just trying to get the basic idea to work)

Dim A(1, 3) As Variant
A(1, 1) = Range("C3").Value
A(1, 2) = Range("D3").Value
A(1, 3) = Range("E3").Value

[Code].....

## Counting The Number Of Times A Multi Digit Number Appears

Nov 22, 2007

I've tried everything I know (which isnt that much to be honest. lol). Ive tried the frequency formula but that doesn't work the way I want it - I think its probably the wrong formula to use. I've also tried a pivot table but they always vex me. If a pivot table IS the way to go, could someone talk me through it step by step? (*the wizard is just as confusing as doing it yourself I find) ....

## Time (clock) Times A Number= Very High Number?

Apr 2, 2009

I have time start and time end and the difference between the two times. In a third column I have profit and want to calculate the profit per hour. When I divide the profit with the time spent I get a very very high number. If I for instance type in 1 hour of work and profit 100, then I get profit per hour 2400. (profit/hours spent)

On a side note I am trying to get the numbers as 24 hours and not use am or pm and in the spread sheet I get these numbers but in the box at the top where you see the formulas etc. it shows as am and pm. I have uploaded an example.

## Vlook Up: Combobox Shows The The First Column (only 1 Of Each) And The Second ComboBox Shows Me The Secondary List

Jun 9, 2006

I have a userform where I have 2 comboboxes. The first combobox shows the the first column (only 1 of each) and the second comboBox shows me the secondary list that correlates to the valuse in the first from column B. Now I have a text box that I am trying to get the value from column C depending on what I have in the first 2 comboboxes. What is the easiest way to do it? This is all in VB since it is a UserForm, and using Vlookup seems to be too many lines if I go that route. Is there a way to use Index and Match in VB where it would be more efficient? I attached just a sample of how the data would be layed out in the Excel sheet.