Search:

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

Page 1 of 6 1

1. Thread: Finding column where data exists

by angiemeh
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. Thread: Finding column where data exists

by angiemeh
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. Thread: Finding column where data exists

by angiemeh
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. Thread: Finding column where data exists

by angiemeh
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. Thread: SUMPRODUCT with cell reference rather than text

by angiemeh
Replies
12
Views
6,207

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. Thread: SUMPRODUCT with cell reference rather than text

by angiemeh
Replies
12
Views
6,207

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. Thread: pivot preserve format not working for clmn width

by angiemeh
Replies
0
Views
924

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. Thread: Vlookup from files where the file & sheet names needs to be looked up also.

by angiemeh
Replies
10
Views
894

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

by angiemeh
Replies
12
Views
6,207

Try this:
...
10. Thread: Filepath not working with Vlookup

by angiemeh
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. Thread: Filepath not working with Vlookup

by angiemeh
Replies
5
Views
655

Re: Filepath not working with Vlookup

Is there any other solution out there?
12. Thread: Filepath not working with Vlookup

by angiemeh
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. Thread: Vlookup from files where the file & sheet names needs to be looked up also.

by angiemeh
Replies
10
Views
894

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. Thread: Filepath not working with Vlookup

by angiemeh
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. Thread: Copying visible cells in Excel using VBA

by angiemeh
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. Thread: Copying visible cells in Excel using VBA

by angiemeh
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. Thread: Copying visible cells in Excel using VBA

by angiemeh
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. Thread: Retrieving Data Using Excel

by angiemeh
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. Thread: Retrieving Data Using Excel

by angiemeh
Replies
41
Views
1,769

Re: Retrieving Data Using Excel

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. Thread: Retrieving Data Using Excel

by angiemeh
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. Thread: Retrieving Data Using Excel

by angiemeh
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. Thread: Retrieving Data Using Excel

by angiemeh
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. Thread: Retrieving Data Using Excel

by angiemeh
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. Thread: Retrieving Data Using Excel

by angiemeh
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. Thread: Retrieving Data Using Excel

by angiemeh
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