Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.01 seconds.

  1. Replies
    8
    Views
    458

    Re: Finding column where data exists

    Thanks!
    This is a good explanation (I will have to read it a few times for it to sink in 100%)

    I Appreciate the help
  2. Replies
    8
    Views
    458

    Re: Finding column where data exists

    Great!
    That worked.
    I understand the 1st formula
    I don't understand the Lookup, why 2? How does it work?

    =LOOKUP(2,1/($C3:$Z3<>""),$C3:$Z3)
  3. Replies
    8
    Views
    458

    Re: Finding column where data exists

    Yes, I only want the value of the 1st instance of the dataset and then the value of the last instance of the dataset. OR, if I knew the row number of the 1st instance and the row number of the last...
  4. Replies
    8
    Views
    458

    Finding column where data exists

    I have a column (row 3) from C:Z some columns have data some do not. I want to find the column where the first data appears and then also the last.

    I want to copy this formula down to the rest of...
  5. Re: SUMPRODUCT with cell reference rather than text

    You could still use concatenate. If in Column G you have =month(A1) etc..all the way down and then Let's say company is in column B(I don't know where it is) and you wanted to sum all the data that...
  6. Re: SUMPRODUCT with cell reference rather than text

    What is "DDD"? I'm not 100% clear what you are trying to do.
    I'll give it a shot:
    Let's say you wanted to meet the criteria of both month and day. You could have your month formula in Column G....
  7. pivot preserve format not working for clmn width

    I am trying to preserve my column width in a pivot table and can't get it to work

    1) I'm in Excel 2003
    2) I have headers that are long (so the column headers are word-wrapped)
    3) I click the...
  8. Re: Vlookup from files where the file & sheet names needs to be looked up also.

    Cool, that worked! I created my text a little different, but the find/replace with = vlookup works.

    I'm thinking I can just create a couple macros that copies the formulas down, makes them a text...
  9. Re: SUMPRODUCT with cell reference rather than text

    Try this:
    ...
  10. Replies
    5
    Views
    655

    Re: Filepath not working with Vlookup

    I'm a little scared if Indirect.exe pulls incorrect values, I'm working on something and we can't make a mistake on it. Thanks for the warning!
  11. Replies
    5
    Views
    655

    Re: Filepath not working with Vlookup

    Is there any other solution out there?
  12. Replies
    5
    Views
    655

    Re: Filepath not working with Vlookup

    I did this, but it didn't work. The more I'm reading, Indirect has an issue with a closed workbook. I found a website that has a morefunction add-in called Indirect.exe and I installed this.

    I...
  13. Re: Vlookup from files where the file & sheet names needs to be looked up also.

    I just posted a similar issue. I'm up for any workaround at this point.

    You mention Using the "&" function & have creating a text expression for the equations you needed to calculate, & then copy...
  14. Replies
    5
    Views
    655

    Filepath not working with Vlookup

    I have 2 files open. File 1 = Just supplier (there are many, File1A_month1,File1A_month2, File1B_month1,File1B_month2... File1C etc)
    File 2 = All suppliers (each supplier on separate tab with...
  15. Replies
    4
    Views
    16,785

    Re: Copying visible cells in Excel using VBA

    Perfect!
    Here is what I came up with from reading that:

    I set the Auto-filter to span 100 rows (knowing I won't get more than this), then I spedified the range b3:f100 to be the same as the range...
  16. Replies
    4
    Views
    16,785

    Re: Copying visible cells in Excel using VBA

    That may be on the right track, but I'm still having issues. The 1st 2 rows are header rows. Row 2 says (first name, last name, commodity, etc)

    I only want to copy columns B through F, so I...
  17. Replies
    4
    Views
    16,785

    Copying visible cells in Excel using VBA

    I have a macro where I'm using an autofilter. I use:
    'Range(Selection, Selection.End(xlDown)).Select and it works great, except for when it can't find the condition.

    If I"m looking for 'Sugar'...
  18. Replies
    41
    Views
    1,769

    Re: Retrieving Data Using Excel

    If #1 starts in Cell A6, you only want to put the formula where # 2 will be. The formula will not be put anywhere else.

    Therefore, you would put the formula in cell A7. The formula would be
    ...
  19. Replies
    41
    Views
    1,769

    Re: Retrieving Data Using Excel

    Follow these steps:

    With your row numbers (they are numbered 1,2,3,,,, etc) Replace the #2 with a formula:
    =if(b3="","",a2+1)

    This Assumes that Row 1 is the header row, row 2 is the 1st set of...
  20. Replies
    41
    Views
    1,769

    Re: Retrieving Data Using Excel

    YAY

    Before we go any further.
    Where do your row numbers start? Will there or should there always be data exactly to the right of the row number.

    So if your row number 1 is in cell A2, will...
  21. Replies
    41
    Views
    1,769

    Re: Retrieving Data Using Excel

    Well... that is what I was trying to get around. The whole Idea behind doing this is to create a macro that automates the steps. You Don't want to manually have to go in there and select the cells...
  22. Replies
    41
    Views
    1,769

    Re: Retrieving Data Using Excel

    Are you on Excel 2003 or what version do you have?
    If you hit ctrl + shift + end you should only select your dataset. So it selected all the columns? Do you have something in the columns to the...
  23. Replies
    41
    Views
    1,769

    Re: Retrieving Data Using Excel

    Did it select the whole sheet or just the area where there is data - which is your dataset.

    If it just highlighted the area with the dataset then the mission was successful and we can move on. Let...
  24. Replies
    41
    Views
    1,769

    Re: Retrieving Data Using Excel

    Actually, this is easier- sorry . Try this and then let me know

    go to the left most area of your dataset. Hit Ctrl + Shift + end (when you hit ctrl, keep holing ctrl then hit shift and keep...
  25. Replies
    41
    Views
    1,769

    Re: Retrieving Data Using Excel

    1st you need to learn how to use Shift + End + Arrows. Practice this and then let me know when you've suceeded and I'll show you how.

    We could also do this using VBA, but since your not familar...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4