appears

Hi I’d like to count the names I am entering in column B so I can see at a glance how many times the name appears. Can’t figure out how to do this. Thank you for any help. Regards

I have a lot of data in a workbook that i want to archive. the issue is i need to determine how many times a specific number appears on that to conduct a trend analysis. Is there a way to conduct a search of how many times a value appears in a different closed workbook? I do know that Vlookup...

I don't know how to post a sample file... but I can describe: I am just doing a match, and it's not working. I want the row number in which the string appears: In A1...

I need to determine which column a specific item is located. <colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody> 1 2 3 4 water lettuce chicken ice cream cola tomato beef cake juice cucumber pork pie coffee okra lamb...

Please help me with coming up with a formula so that the value "1" appears on the corresponding row of a column for every first instance a code appears on another column. Like this: A B 1 GL23 1 2 GL45 1 3 GL45 4 GL50 1 5 GL23 6...

I'm looking to create a formula that 'rank' an occurrence in the file, I guess similar to the count function but rather than the number of times it appears, I want where it appears in that range of occurrences. <tbody> Column A Desired Result <tbody> Belgium </tbody> 1 <tbody>...

Hi there, I have been working on a spreadsheet for multiple days now trying to deal with one formula in particular which i can't fathom out. I shall try to explain; I want to calculate; IF "X" number appears on any line in column E (Sheet 4) and also appears in column I (Sheet 3), then the...

Hi, I now how to count cells that contain certain numbers in a range but how do i count if a number appears in a certain selection of cells. In the example below each there are 4 repeating columns. I would want to count how many time a 7 appears in each column with the title "C" which would...

Hi and thanks in advance if you reply. I have an intermittent problem! Have 2 access databases (2010) say 'A' & 'B' If I open 'B' from 'A' sometimes 'B' appears on top but other times 'A' appears on top. The two questions I need answering are:- a) What code do I have to include to make 'B'...

Whenever I enter anything into a cell, a vba window appears saying can't find project library. I press ok then another window appears with a checkbox highlighted which says there are missing microsoft windows common controls. What do i need to do to get rid of this?

Hello all! I have a pivot table that has an https address in the raw data, which appears in the drill down results. It looks like: + Supervisor name ....+ Representative name ........+ https:// All this appears in the same column, of course. I've found so many VBA's online that "should" load...

Thank you for looking at my post. I want to know how to do the following. If I want to know how many times the number 2 appears in a set of numbers that are in one cell. The set of numbers in cell A2: 12 02 44 26 91 55 62 I've tried the formula:=ISNUMBER(SEARCH(SUBSTRING,TEXT)) to find it...

Hello, i don't know why, but if i write "IF(A1=1;"TEST";"TESTE2") I probably deactivate 1 function of excel, when i write IF, it should appear "=IF(CONDITION, VALUE IF TRUE, VALUE IF FALSE") now, nothing appears i need to guess all formulas work, can you help me out enable this "help" function

Good evening, I have a issue which I hope someone can solve for me . Cells E2 - G2, when a certain task is done, the user puts a "Y" into the applicable. However some users are putting in more than 1 Y into and this gives the wrong count. Is it possible to have it so that only Y can be put in...

Hello ALL any help would be great Mini Report Tab in E3 i would like a formula to work out the amount of parts that has been built between a time of 06:30 - 14:30. but specific for the part numbers that appears in in column A

I have a sheet that comes out in a terribly unfriendly format. It has a date that appears in column C at variable intervals to denote the day that the times underneath it occurred. I'd like the first instance of the date in C2 to be copied to A2, and then still paste that same date value into...

Sheet 1 has a column with a number of values selected from a drop down list (This 'Main' list is defined on a separate sheet 3) Sheet 2 column A reflects the 'Main' list then column B uses a countif statement to count how many times the value in A appears. (See below) <tbody> a b 1...

Hi all I had a combo clustered/stacked chart that up until mid last week was working fine as far as value labels were concerned. Since then I have had the Office upgrade, and the Labels have busted. Specifically, the chart is filtered to only show 3 months of the year (May/June/July). The...

Hi all, I have a long list of email addresses from my business's newsletter subscription list, most of which are repeated multiple times within the list. I'm going to send this email list to someone to do some analysis, so I want to make sure the don't have access to the real email addresses...

Hi, I have a series of data running across a number of columns. Where a certain word appears in the data, I am wanting to colour fill the 3 cells to the left of it. Using the below example, where the word Dog appears, I would like the 3 cells to the left of the cell containing the word Dog to...