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

Some videos you may like

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...
Top