Hi, I am extracting data from a Microsoft Project file into Excel and need to write a formula to grab some data. It has a header called "Build" and then another header called "System Build". I want all the rows in between those to be labelled "Build".
ex.
<tbody>
A
B
C
D
1
Name
Start
End...
Newbie here so please be kind. lol
So what I have; a lot number(1234) entered into H1, a station ID#(A,B,C or D) in H2 and the current date and time in H3.
What I am trying to do is reference the lot number and station ID# then enter the current date into that intersected cell.
<tbody>...
Hi all, i’m ok with excel and simple vlookup but i’m not getting anywhere after looking all over the internet for hopefully a simple formula.
i’m doing a vlookup which will return specific data related to UK0006 against sheet 2 column B for station- CCTV for example. As there are multiple UK0006...
hi all,
kindly anybody tell me short cut to find out desired output if possible.
i have a record on station wise separate sheet. 50 sheets station wise.
i apply:
=VLOOKUP(F2,A2:D7,3,0)+VLOOKUP(F2,Sheet2!A2:D7,3,0)+++++
this is too lengthy.
is there any short cut to find Vlookup countif, SUMIF...
I'm not sure if this is the right way of going about this, but hear me out.
I have a list with a bunch of work centers in our building. When a user clicks that list, they want to be able to bring up a map and see where that work station is located.
I was thinking of using coordinates (pixel...
Hi all,
I've seen the topic in a variety of posts, but for some reason, I am having challenges getting a working model.
The idea is that the master list of values (which has duplicates), will be updated often via a copy and paste of an updated column.
The number of rows can vary, so in the...
I have a sheet with thousands of rows of data. I have one column with different 'stations'. For example, column D is where my stations are and the data is 1A, 1B, 1C, 2A, 2B, 2C, etc. Each station has approximately 1500 rows/incidents of data that pertains to it. One of the columns...
Hi All,
Hi time poster (because I'm stuck!!). I've two tables both have a number reference and a start time. I'm trying to index a text column in one table, match the number and start time and show the text in the other table. Not a problem I've used to following formula...
Hi Guys,
<tbody>
Order #
Part Count
Estimated EOL
Station 1
Station 6
End of Line
123456
3
17/6/18
12/6/18
14/6/18
18/6/18
234567
5
19/6/18
14/6/18
15/6/18
ongoing(left blank in my data)
</tbody>
Please see the table above - it's essentially a sample of my dataset. I want to achieve an...
Hello All,
This is my first post, so first of all, I apologize if I am doing something wrong.
I need help with a formula that will fetch data from a cell or number of cells in a column by matching today's date with another column of dates.
<colgroup><col><col><col></colgroup><tbody>...
Hi All
I am trying to make a dynamic reference to a table array in a Vlookup formula.
The Table arrays points to a closed workbooks "C:\Dropbox\Agriseed\Present Trials\2018\Grass\Perennials\[Trial Data FLP1801.xlsx]FLP1801" So i can't use Indirect to the first table below.
In B5 of the second...
Hi,
I have a problem where I am trying to VLOOKUP a certain code from a range but the source field has the target string in a larger "messy" string.
E.g. trying to search the cell "Y:\Certificates awaiting approval\1 Station Road TMV Dalex 090118.pdf" for the string "1 Station Road" and return...
Hi,
I am trying to figure this one out, Hopefully someone can help me.
Basically I have a sheet like this:
<tbody>
Post Name
Announce Desc.
File code
Audio file code
Station 1
Station 1_welcome
112
B76
Station 2
Station 2_welcome + Dept.
1009
Y677
</tbody>
I have a separate sheet with...
Hello,
I have a report which needs data populated into it from a downloaded file. My report looks a little like this. I need to pull the data from the second table into this report. I was going to do a lookup but since the Part# duplicates i knew it wasn't going to be that easy. So since...
Hello everyone, I have a bit of a situation that I can't seem to be able to resolve. I'm currently using excel to keep track and sort 50 patients at the same time for research purposes. So in my main worksheet, A1:A50 are the patient's "station number" and B1:B50 are the patient's names. Columns...
I have in column B non-duplicate information and I need to bold over 600 lines in the manner below.
WGHI(Studio)(Los Angeles, Cali) Radio (Nov 1, 2017) - Top 10 Radio Station
KAWG (CNBC)(NY, New York) Television (Nov 2, 2017) - Top 10 TV
and so on and so on for 600 rows what I need is...
Good Afternoon
I wonder can someone help. I have multiple Excel Files in one Directory.
1. I need to Open Each one in turn.
2. Activate a given Sheet. The Sheet Name will vary from Workbook to workbook (E.g Station 1, Station 2 , Station 3)
3. Print the Selected Sheet to my default...
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.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
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
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
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.