Most common question

And what if we provided the "standard" answers in this thread ?
Then we can all refer to here :-)
 

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.
How do I send a mail with attached:

the complete Excel file
only the active sheet
no attachment but I want a certain range or cell in the message

There are days you'll find this question 3 times in a row...

The answers can of course be found here:
http://www.rondebruin.nl/sendmail.htm
 
Don't forget the ever popular
"How do I move a row from Sheet1 to the next available row in Sheet2"?
and
"How do I write an IF formula with more than 7 conditions?",
though I would have to agree with Kristy and say the multiple condition SUMIF is probably the most popular.
 
er...that wasn't me
It appears that the brain isn't firing on all cylinders today! You were the last poster before my reply, not the first. :oops:

I agree with Guentjo's initial post! :-P
 
How about this one?

I have X number of worksheets/books and 1 'master' worksheet/book how can
I get all the data into the 'master' automatically whenever the other sheets are updated?
 
We are all missing the most obvious one.

"Can you post a sample of your data?"
 
XLGibbs

That's not the most obvious one.:)

Surely it's 'What exactly are you trying to do'?
 

Forum statistics

Threads
1,222,738
Messages
6,167,905
Members
452,155
Latest member
Prakash K

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top