# locate

1. ### Locate consecutive sequence of values & return column header name

Hi All, Background: I have used the following formula to calculate the highest sum of 3, 6 or 12 consecutive columns in my dataset = SUMPRODUCT(MAX(B2:V2+C2:W2+D2:X2+E2:Y2+F2:Z2+G2:AA2)) # this example is for 6 consecutive columns and returns the result 15, See screen shot #1 below, under the...
2. ### Lookup and Find

I feel like I should know this but am drawing a blank. I have a table of 3 columns and 10 rows and two values to locate. In column 1, I want to find the number 29850 and I want to locate in column 2 the term "report" and return the value in column 10. So an idea is as below: <tbody> Sequence...
3. ### Vlookup based on Moving Target range

Hi everyone, Pulling my hair out today trying to figure this one out! I have a large reference doc where the given value I'm trying to locate can be found anywhere between columns J - U. From there I need to lookup the value in column AA, hence my vlookup range is somewhat dynamic. I am already...
4. ### Macro to Move Data

Hi I have data located in 1 row across 4 columns in many different ranges, an example is: cell C38 cell D38 cell E38 cell F38 10-18 1.00 2.00 3.00 This is only my second post and I think this is possible so here goes. I was looking...
5. ### Finding number between range of numbers?

Hello i'm trying to locate a number between a range of numbers this way: range of number for example 538000 - 538499. trying to locate the number 538125 that is the range of the numbers 538000 - 538499 and mark the cells with color. in addition to make things easier for me i names the cells and...
6. ### locate the position of a given value in a given column in Excel

Hello, my vlookup did return a value however I thin it is lying to me. When I have a filer on the column and look for the value as a check, it does not appear. When I try a control f the value does not appear. I have not tried an index match yet. Is there a simple formula to locate the...
7. ### Missing linked data file

I am trying to help out a coworker who has an excel file embedded in powerpoint and when she tries to edit her graph that's in powerpoint she gets a pop up error that states, "The linked file isn't available". She states that she has always accessed the data via this route and has no idea where...
8. ### Macro cannot "see" protected view file

Hello guys, So i created a command button macro that locate a file with a specific name but it seems that if the file is in "protected view", the macro cannot locate the file... If i enable editing, it does work... If i don't it can't locate the file I feel like i tried everything...
9. ### VBA Counting instances of journeys

Hi I need to use VBA to count how many times a journey occurs in each Quarter. I have a table which shows the Journeys to be counted (in either direction) D:E, along with the various journeys per Quarter in column A. So in the example below. the journey London to Cardiff (either direction)...
10. ### Request for Excel Files that go with the 54 Book

Hello, I recently purchased The 54 Greatest Excel Tips of All Time and I am needing the files that go with it. I can't seem to locate them with the information from the book. I appreciate the help.
11. ### Locate circular reference - cell cannot be listed

I have a worksheet that inform me that it has circular references, and excel cannot locate it for me. I could not find the wrong value. This worksheet is complex, and more importantly, too important to have errors in it. Is there a way (VBA or not) for me to locate this circular cell...
12. ### #REF location ? POssible

HI i have on sheet1 the whole sheet full of alot of stuff. Going past 5000 lines. Is there a formula i would prefer or even a macro I can put on sheet2 to locate on sheet1 where any cells that have #Ref . It takes forever to find thanks
13. ### Insert Pic based on Selection

I have a sheet called "Main" In Cell B3 I have a drop down list, Whatever I choose here I want a picture to appear on Main starting in Cell E3 I can either have the pictures stored on another Sheet or from a Folder which ever is easiest, by choice i'd like it to locate the pic from another...
14. ### VBA select two columns using column numbers

Hi: I'd like to be able to select two columns at the same time (not the columns between them - only those two columns) given that I have two integers that locate those two columns. Thanks!
15. ### Locate duplicate values in a column, copy/paste adjacent value

I'm working on a report with thousands of entries. For some reason, the report only returns data in column C the first time a value appears in column B, for all subsequent entries of that value(B), Column C remains empty. I need to locate all duplicate values in column B, and copy the value of...
16. ### Locate 1st column that does not contain A, B or C

Hi all, I have a spread sheet with c.20k rows of data with 8 columns in the following format: Comp1 Cost1 Comp2 Cost2 Comp3 Cost3 Comp4 Cost4 Under the Comp columns there are multiple (c.100) codes. I'm trying to locate (for each line) the 1st 'Comp' column that does not contain U7,UN or...
17. ### input box, row locate

Hi again, I am here again seeking help... What I am trying to accomplish is that, I wish to show an input box where I will input text or number, then a macro will locate the range and identify the row number, then there will be a code for that certain row. Then it will loop until there is no...
18. ### Finding Number on Col G and put an "X" in Col M in the same ROW

I need to see if there is a way to this: Cell A1 I can enter a 4 digit number. Click a button to run a macro that will go to another sheet in my workbook, Look in Col G ( there are hundreds of numbers) and locate that certain number on the ROW and on that same ROW place and "X" in col M so it...
19. ### Graphs keep disappearing in my sheets - Excel 2013

I have an Excel 2013. Embedded graph disappear sometimes when I open my sheets which I cannot locate.
20. ### how to assign events to controls on [ Microsoft Forms 2.0 Frame ]

On a worksheet, I have created a MS Forms 2.0 Frame and added several commandbuttons onto it. But how can I code some events into the commandbuttons? I can't locate their names and appearance in VBE and elsewhere. The reason of using Frame is to fix the positions of a bunch of already-made...

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back