appears

I have a spreadsheet with formulas in certain cells - for example in B2 I have =IF(A2="","",(B1)) but if I enter a date in A2 nothing appears in B2 unless I select B2 and click the fx button and okay the box that appears. I did read to check that I hadn't selected Text for these cells but I...

When you go to create a Macro, based on an Event, there is a selection for "Requery" When you select that it comes up with a filed below it titled "Control Name". It appears that it wants the user to enter some kind of information. What is the Control Name and what kind of information/data is...

Hi, I have a series of questions in rows where there are corresponding drop down menus for each question. The questions appear one by one depending on the answer to the prior question. When a new question appears there is a delay before the corresponding drop down menu appears. The viewer sees...

Hello all, I have a spreadsheet that has a cell that when one answers a series of questions a value appears in that cell. I would like to lock all of the questions after the answer appears. Any suggestions? Thanks.

(Image)https://www.dropbox.com/s/2sz7hspvq6n4edk/Image.jpg?dl=0 Hi, In the image cell C14 is a drop down to determine which filling point (Meter) I need to use. In the Image 3 & 4 was selected, so Meter 3 appears in cell E19 and Meter 4 appears in cell H19. I'm going to focus on Meter 3...

I have cell J11 with a drop down list which are 1,2,3,4. I need that: 1. When I choose 1, in cell c16 appears cell 'Tank 1'!E9 2. When I choose 2, in cell c16 appears cell 'Tank 2'!E9 3. When I choose 3, in cell c16 appears cell 'Tank 3'!E9 4. When I choose 4, in cell c16 appears cell 'Tank...

I have cell J11 with a drop down list which are 1,2,3,4. I need that: 1. When I choose 1, in cell c16 appears cell 'Tank 1'!E9 2. When I choose 2, in cell c16 appears cell 'Tank 2'!E9 3. When I choose 3, in cell c16 appears cell 'Tank 3'!E9 4. When I choose 4, in cell c16 appears cell 'Tank...

Hi, I have cell C12 with a drop down list which are 1 & 2,3 & 4,5 & 6. I need that: 1. When I choose 1 & 2 from the drop down, cell E17 appears as METER 1 and cell H17 appears as METER 2. 2. When I choose 3 & 4 from the drop down, cell E17 appears as METER 3 and cell H17 appears as METER 4. 3...

I go to data and edit links.It appears there are link to another workbook.If I try to break link. The link does not disappear.I try Ctrl + F in the workbook and search for the link, but no search result.How is it possible to delete a link or how is it possible to find where in the workbook it...

hi, two questions: wondering what the most efficient way to write these would be - without just combining multiple countif functions on top of one another to do this without using an array? 1: count the number of times any of the following appears in column R - ABS, BND, or FUND; while...

When I type a formula designated for a specific cell (e.g. C6), the text of the formula appears in the cell, rather than the numeric result. When I delete the text in the formula bar, it remains visible in the cell. If I type new text in the formula bar, the original text remains visible in...

I was working on a project where I have items that appear in a list multiple times. They are all sorted alphabetically and I wanted to get a formula that would count it appears while going down each row. If had a list of 3 items in Range(A1:A3) I would have a formula in column B that would...

I have 2 columns, one with names and another with numbers. I want to extract in a continuous list the numbers that match a certain name. (eg, if A appears 3 times, i want to have a continuous list (vertical or horizontal) with the 3 numbers that match the A) How do i do that?

First off, I believe there is a previously answered post but I can't find it for the life of me. I am looking assign a short cut to a macro that places the cursor in the Name Box so I can enter the desired value. I don't want to use the dialogue box that appears when you press F3. I would like...

Hi All, l'm wondering how can l setup the formula for the situation below: If column A appears more than one times, it will count from A to ZZ. If just only appears one time, then just shows ZZ. A B ---------- 1 A 1 B 1 C 2 ZZ 3 ZZ 6 ZZ 1 D Any ideas of how to...

Hello all, I have attached a file which demonstrates this. In my real document, I have about 3,000 rows. The formula in P is: =COUNTIF(A2:L2,"*"&"tour:"&"*")>0 This works 100% of the time. The formula in Q is: =IFERROR(CELL("address",INDEX(A2:L2,MATCH("*"&"tour:"&"*",A2:L2,0))),"")...

Hello, I am trying to eliminate rows that have a certain word in them. All of the words are in the same two columns. In this case either B or F. So, if the word appears in column B or F I would like the code to identify the word and then delete the row. I am intermediate level user and...

hello, i have a list, example, a , b , b , a , a , e , a i want to get the individual counts of a value before a change in value. if i use "count", it simply gives me a=4. another issue is that the value "a" appears again later in the list. i want the output to be, a,1 b,2 a,2 e,1...

Hi I've got a table where I want to add the sum of occurrences for two different letters (see below): A appears twice, B appears thrice and C appears 4 times. Assuming that this data covers two columns and 4 rows from cell A1, how would I write a SUMIFS formula that captures the number of...

Hi Rank(F2,F2:F42,1) works in the first cell, but when I try to paste down to F42, an error appears in all cells apart from F2. Thank you for your help. Regards