I misunderstood, thought you wanted to be reminded.

You don't need those Outlook references enabled because we're using "generic" objects. Enabling them let's you specifically use Outlook objects and gain increased functionality which we don't need here.

For looping through the dates in column A - set a range variable for the whole list. Then you can evaluate each cell using IF (or SELECT CASE can be easier if you have multiple scenarios). Use OFFSET to refer to the other cells in the same row as the particular date you're looking at.

Whoa code tags don't work on the forum app?

I paste text into Excel and use text-to-columns format it.

But then Excel assumes all future pastes are to be text-to-column, and it screws up the spacing and I never get into the text-to-column "wizard" becuase Excel has already "done it" for me. How do I get Excel to stop assuming the texttocolumn format I want?

Who here dreams in Excel?

(I have)

Ha this happened to me today, so annoying. Didn't have time look for a solution yet. Post if you find one.

For the code on email, you really want to look at the email provider. There are simple aps out there that show how to use both outlook, or send the email from another email service. Both my personal and work accounts are hosted by google, so I just use that bit of code to send out the emails. Sending gmail is pretty easy once it's set up.

The only solution I've managed to find is to click on a cell, open the wizard, and reset the parsing selection. Then go paste in the new data. Haven't found an option to turn off the auto parsing otherwise.

Pivot tables are the worst in Excel, I hate them, they suck, they are useless to me.

Anyways, got a problem, please help me anyone:
http://www.mrexcel.com/forum/excel-q...ml#post3567662

I dont think there is a way, but I need it confirmed.

I am trying to do an if statement for some cells and it works sometimes and not the other. it is excel 2007. it is =IF(sum(B11)-G1=0, "", "OOB"). I filled it down and it works on some rows but not others even though it does equal 0. On some it is saying that the value is -3.645564654E-12 (something like that). Is there an easier way to do it?

Try to use ROUND(sum(B1:X1)-G1,2)=0

You can change the 2 to something that accommodates your needs.

hi, i need to learn how tu use excel for school and i dont know much except for the very basics.

anyone know a good site or good vid to learn as much as i can, dont wanna buy the book. would be much appreciated, thanks.

I want to lookup/match a value that has multiple occurrences in a table. But instead of returning the first instance, I want to return the last. And I don't want to re-sort the table.

Example:

Lookup value = "apple"

I want to return 7, not 5. Again, I don't want to re-sort. I want it in a formula, not VBA.

Any ideas?

Ok nevermind:

{=MAX(IF("APPLE"=A:A,ROW(A:A),0))}

Gives the row number.

In pivot tables Excel 2007, is there any setting I can change so that Value Field settings parameter defaults to Sum instead of Count?

MS appear to have changed this in 2010, but I do a large number of pivot tables in 2007 at work and it would save a bit of time.

I haven't really used 2007, but might it have something to do with the data type? Is it all numeric?

i believe so, but i might run some tests, cheers

Newbie Excel problem:

I'm having an issue using the SORT feature in Excel 2007.

I have a spreadsheet with titles along Row 4 and data down each column from Row 5 to Row 133.

In Column C, I have the first set up data (Names).
In Column D-P I have dates
In each corresponding Row (starting in Row 5 and ending in Row 145) I have a number value for each name for that date.

I'm trying to sort names alphabetically, while keeping the persons data associated with that person. The problem I am having is when the names sort alphabetically, the number values aren't sorting correctly with them.

For example, Bob (C11) has a 25 (D11) for January (D4). When I sort, Bob is shifted correctly alphabetically to (C22), but he no longer has the value of 25 for January (which should now be at D22).

This is how I am trying to sort:
I select/highlight C4-P145
I click Sort, then Select sort by "Names" in order A to Z
This rearranges the names alphabetically, but also adds some blank spaces randomly throughout column C. This seems strange as there are no blank entries in my original spreadsheet in this highlighted area between C5-C145.

What am I doing wrong?

Any help sorting this spreadsheet would be very much appreciated!!!

Are any of your cell entries formulas or pulling data from another sheet?

That's my first though. If there are formulas, the formulas can get jumbled up in a sort.

That was the problem!!!

Not sure why, but many of the name entries in Column C were listed with formulas. The cell would show the name, but when I click on the actual cell, I would see a formula in some of them. For example C5 had "=UPPER(B5)" in it. C9 had "=UPPER(B9)", etc...

Weird!

I went through and replaced each cell with a formula in it with just the name and it then sorted correctly.

Thanks guys!!!

this is prolly the dumbest question asked here but its been bothering me forever!

how do you press enter in excel?

tried alt+enter but it doesnt work

I usually use my right pinkie finger.



(Sorry, but I'm not sure what you mean.)

Shift + Enter maybe? I thought Alt + Enter was the way to go.

no neither of those work, can it be disabled or something?
how do you turn off/on shortcuts?

Really depends on what you are trying to do.

A line break can be achieved with alt + enter or through find and replace using alt + 010.

If you just want to hit enter and move down a cell, go to tools > options > advanced and make sure that "After pressing, enter..." is checked and "down" is selected.