locate

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...

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...

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...

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...

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...

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...

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...

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...

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)...

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.

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...

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

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...

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!

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...

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...

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...

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...

I have an Excel 2013. Embedded graph disappear sometimes when I open my sheets which I cannot locate.

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...