Search:

Type: Posts; User: trekker1218; Keyword(s):

Search: Search took 0.00 seconds.

  1. Re: Condition formulas from text list to table

    Thank you. I had that same formula and missed the >0 part.

    thank you.
  2. Condition formulas from text list to table

    Hello,
    I have a list of text data in cell AQ2:AQ430
    i need to find every occurrence of that list across cell M2:AP500
    Then Highlight the matches only.
    I have gone through plenty of permutations...
  3. Re: Trim / Cut and Paste excess from the next space.

    works great. thank you.
  4. Trim / Cut and Paste excess from the next space.

    hello all,
    I am currently working on a web site with a description column that cannot exceed 75 char. The data I have exceeds that in certain circumstances.
    Is there a VBA or formula you all know...
  5. Re: SO Close and yet so far. Simple answer Im sure.

    Yes and no...

    =INDEX('Sheet10'!F2:I100,MATCH(Item#,'sheet4'!F2:F100,0)*(MATCH(Attribute Label,'Sheet4'!H2:H100,0))
    raw data for items , find matching item #, match...
  6. Replies
    15
    Views
    832

    Re: Index and Match problems.

    Hello, again,

    This file has been a life saver. I have run into a runtime error when i try to sort more than a 1000 rows of data.

    I basically narrowed it down by trying 5000 then 4000 and so...
  7. SO Close and yet so far. Simple answer Im sure.

    Hello,
    i have a book full of item numbers for an ecommerce site. The template requires me to segregate the upload data.
    I need to Index RAW DATA on sheet10 and place into Sheet4.
    Step 1 is to...
  8. Replies
    0
    Views
    229

    using index with multiple conditions

    Hello all,
    I am trying to match 2 cells and post result of another cell. here is where I am now. I have 100 attribute labels and attribute values in one workbook. Need to extract the matching Item...
  9. Re: Looking to DELETE all ROWS in Entire workbook with 8 sheets.

    Hello,
    The code did not work.

    I need the code to remove all empty rows and possibly reset the last cell used. When i press CTRL+END it jumps way past data filled cells to empty cell at row 1000...
  10. Re: Looking to DELETE all ROWS in Entire workbook with 8 sheets.

    Will do in morning thank u very much
  11. Re: Looking to DELETE all ROWS in Entire workbook with 8 sheets.

    Sorry. The data to check will be a2 to cc2000.
    If entire row is empty then delete row.

    Then goto next sheet in workbook.

    Repeat.

    Thank u very much.
  12. Re: Looking to DELETE all ROWS in Entire workbook with 8 sheets.

    An empty row would be considered anything with a and then the rest of the row empty
  13. Looking to DELETE all ROWS in Entire workbook with 8 sheets.

    Hello,
    I need a way yo delete ALL empty rows in an entire workbook with 8 sheets.

    I found a few here and they do not seem to work for more than one sheet.

    Any help would be great!

    Thanks...
  14. Replies
    1
    Views
    413

    Combining Worksheets into one

    hello, You guys were extremely helpful with a previous problem several months ago. I am going to the well once more.
    I have a few hundred workbooks that need to be combined into a single.
    They...
  15. Excel Crash if I select any auto complete formula from dropdown

    hello,
    I have searched the internet for an answer. and all I found was answers to turn autocomplete off. Dont want to do that.
    Here is what happens. When I start a formula ( =vl ) a drop down...
  16. Replies
    15
    Views
    832

    Re: Index and Match problems.

    "WOWWWW" Sorry for the delayed response. Was traveling and could not access these files.
    Incredible solution. You all ROCK>>>

    THANK YOU>
    Tino
  17. Replies
    15
    Views
    832

    Re: Index and Match problems.

    Hello,
    I am enclosing a secondary sheet with more rows for you to review. I notices some data is still incorrect with your formulas. ...
  18. Replies
    15
    Views
    832

    Re: Index and Match problems.

    Hello,
    That is workable. Thank you. However, what do I need to change if the ROWS are increased from the sample file. The sample had 35 rows. I have over 300 files to do with various amounts of...
  19. Replies
    15
    Views
    832

    Re: Index and Match problems.

    Hello,
    I only manually sorted up to column AK as you can see. I do need to sort ALL columns. The Attribute Labels need to match the Values in next cell to the right.
    I was using a blank sheet with...
  20. Replies
    15
    Views
    832

    Re: Index and Match problems.

    Hi,
    The data is for my company web page. I need to upload the data into a content manager in a particular format (Sheet2)
    The column sort order does not matter. But the Rows must remain in the...
  21. Replies
    15
    Views
    832

    Re: Index and Match problems.

    Marty, Thank you for responding. Here is a quick sample. The data is in the middle of the sheet and I can't shift empty spaces. I am using a blank sheet to reference this data with the Index and...
  22. Replies
    15
    Views
    832

    Index and Match problems.

    I am trying to line up columns of data that are all jumbled. Example. length x width x height are in my sheet in a row. But are in different columns. I've tried to Index and match to no avail. How...
Results 1 to 22 of 22