station

  1. S

    Label All Fields Under a Header

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

    Cell Referencing with auto populating another cell???

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

    vlookup specific data

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

    Short Cut Data Find Against V-lookup, SUMIF, COUNTIF

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

    Placing a "Pin" in a PDF?

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

    Extract Unique values except blank cells

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

    Need help with formula when data changes in column

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

    Index match a time to +/- 3 seconds (If it's possible that is)

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

    Plotting 3 data series with different dates on 1 chart!

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

    Getting Info from Today's Date

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

    dynamic reference to a table array vlookup excel

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

    Fuzzy VLOOKUP using a Range of Values

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

    IF formula help populate other fields

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

    Lookup Formula?

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

    Trouble with hyperilnks and sorting rows

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

    How to bold partial text string for over 600 rows

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

    Multiple Open Files

    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'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.
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.
Go back
Back
Top