Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: frantzx
  • Content: Threads
  • Order by date
  1. frantzx

    Wondering if this is possible

    I have a spreadsheet I'm trying to figure out. Below is my data: A B C Exception Date Units short 3/3 2 over 3/3 3 short 3/3 4 short 3/3 1 over 3/3 5 What I want is in a seperate column to show how...
  2. frantzx

    Listing matches in Excel

    Sorry if this has been posted before, I'm fairly new to this. I'm looking to list matches or duplicate cells found in my spread sheet. Here's an example of what I have: A B C D E R-1-A1A1 R-1-B3A2 R-2-S1W4 R-3-G23P4 R-4-Y4I7 R-1-A30M2...
  3. frantzx

    Macro Help

    I have a question regarding macros. I built a macro in the order I want things done in my work book. But for some reason when I run the macro it will do the last part first, then it will run the rest of the macro.I think it may be doing this because the last part of my macro is a quicker process...
  4. frantzx

    Macro Help

    I have a question regarding macros. I built a macro in the order I want things done in my work book. But for some reason when I run the macro it will do the last part first, then it will run the rest of the macro.I think it may be doing this because the last part of my macro is a quicker process...
  5. frantzx

    Extracting a certain portion of a cell in Excel

    I need some help. I am trying to extract a part of a cell with a formula. See example below: in column A1 my data is P-1-B103A4 P-1-B103A5 P-1-B107A10 P-1-B107A12 P-1-B10A7 P-1-B10A8 P-1-B10A9 P-1-B10B12 in column B1 I will need just the numbers that will come after P-1-B: 103 103 107 107...

Part and Inventory Search

Back
Top