A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Post New Thread
Threads in Forum : Excel Discussion (Misc queries) Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
1 Attachment(s) Sorting dates in Pivto table by Excel Dumbo
Dear friends, Please find attached sheet I would need to create two pivot table with the below column headings Pivot table 1 Column heading-...
January 17th 17 01:39 PM
by Claus Busch Go to last post
1 296
% Profit Loss Formula by Jack
In my Excel spreadsheet I have these values: A1= 0.0001473 A2= 0.0001620 I want to find the difference when I have a Long Sale and the Difference when I have...
January 17th 17 04:10 AM
by Jack Go to last post
1 217
Grid lines obscured by fill color by Paul
When I apply a fill color to a block of cells, the grid lines don't show in that block of cells. I don't expect that there is a way to force the grid lines to...
(Multi-page thread 1 2 3)
January 16th 17 12:48 PM
by lbsaunt@quartic-training.com Go to last post
21 5,226
Protect an Excel WorkSheet from being deleted by Trader_in_Paradise
I have a blank WorkSheet called "Scratch" in an Excel workbook with lots of VB code. I want the user to be able to do anything with the blank WorkSheet...
January 16th 17 08:13 AM
by bondblake759@gmail.com Go to last post
6 2,303
How secure is Excel 2007 worksheet protection? by Greg Lovern
I have a friend who wants to protect the formulas in his workbook from being seen. Is the worksheet protection in Excel 2007 any more secure than in earlier...
January 16th 17 08:02 AM
by bondblake759@gmail.com Go to last post
3 783
Day Trading Spreadsheet by Jack
I have created a spreadsheet that captures all the trades that I make and does a few calculations for profit/loss and stop loss calculations. While a trade is...
January 15th 17 04:42 AM
by Jack Go to last post
0 164
Using text values in Pivot Tables by Eric
I am creating a simple pivot table with one field of values, numbers to be summed, and a second field, occasional two letter alpha codes which are...
January 14th 17 05:36 PM
by 4815162342.mn@gmail.com Go to last post
9 3,065
Excel insits that I use absolute cell references by Espen
Sometimes if you are referring to a cell in another sheet (in the same workbook) Excel decides for no apparent reason that all your references should be...
January 5th 17 06:47 AM
by mackmans51@gmail.com Go to last post
6 699
How to send messages from computer by Hbkkiyt
Want to send text from computer ? Or want to group texting people from computer ?Coolmuster How to Print Text Messages is the smart Android messages backup...
January 5th 17 06:35 AM
by Lansjter Go to last post
3 1,081
SUMIF function and cell /sheet reference by apache007
Dear Excel Experts, I have the following tables on my sheet 11 Mar 09 SUP1 $30 1 Apr 09 SUP1 $50 2 Apr 09 SUP3 $10 4...
January 3rd 17 08:51 AM
by maryjhon830@gmail.com Go to last post
4 526
Simple Charting Problem, Please by Bob[_19_]
Hello, Using Excel from, I think, 2007, and Windows 10. Haven't used in a while, and I am probably forgetting things, but this is really confusing me. If...
(Multi-page thread 1 2)
December 27th 16 04:56 PM
by kqxsmn Go to last post
11 527
Remove Numbers from Alphanumeric String by Dave
Hi, I have a value in Cell A of ABC123. I want Cell B1 to contain the 123 from this cell. Can anyone tell me the formula to enter in B1. I'm sure I've seen...
(Multi-page thread 1 2 3)
December 25th 16 03:33 AM
by Thế45363 Go to last post
27 2,085
Angry
Scroll bar disappears by Michael Graubart
I have upgraded to MS Office 2016 on my Mac with OS 10.12.2 (Sierra). In the computer's System Preferences/General I have scroll bars selected to be visible...
December 14th 16 06:03 PM
by Michael Graubart Go to last post
0 308
Trapped in a cell! by mckinneyalex@gmail.com
On Wednesday, October 23, 2002 at 2:01:10 AM UTC-4, Hudan wrote: > After creating a data table, I double clicked into a cell > and deleted its contents. When...
December 14th 16 09:39 AM
by DungSports Go to last post
1 462
Mail merge from excel to word SUCKS by danny1234
Hello, I have a excel sheet and I just want to print labels on a a4 page with 3 columns and 5 rows. This seems to be impossible with WORD 2007. I use mail...
December 13th 16 08:26 AM
by Sandytran144 Go to last post
6 1,636
merge two excel files like in word mail merge by azmerritt
can you merge a list of names that is in an excel spreadsheet (client listing) into a "document" that is also done in excel? I'm trying to do "mail merge"...
December 11th 16 10:23 PM
by TabooCheddar Go to last post
1 1,931
Choose function not working by Dave1972
Excel Masters, I can't get my choose formula to work =A2*(CHOOSE(INDEX(MATCH(B2,period,0),1),52,26,12,2)) Essentially doing up a home budgeting sheet that i...
December 11th 16 12:15 PM
by Claus Busch Go to last post
3 331
Coverting Lotus 123 files to use with excel by pako10alan@gmail.com
On Sunday, June 20, 2004 at 2:18:07 AM UTC-7, Harlan Grove wrote: > "Muffin1947" > wrote... > >I have several hundred...
December 11th 16 03:13 AM
by pako10alan@gmail.com Go to last post
0 290
DROP DOWN MENUS with formulas by curiousgeorge
I am trying to create an easy budget. I have a drop down menu with pay periods or bill payments as daily, weekly, bi-weekly, monthly etc. These are all in a...
December 10th 16 10:19 AM
by Dave1972 Go to last post
6 791
Pivot ungrouping on refresh? by Me!
Hi, I have a pivot table where the ROW field is a date that is grouped by month & year. However, when I change the data source to include additional rows...
December 9th 16 06:50 PM
by rodog311@gmail.com Go to last post
6 2,336
Post New Thread


Display Options
Showing threads 21 to 40 of 146436
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 06:48 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright ©2004-2017 ExcelBanter.
The comments are property of their posters.