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
Collect deraqilos from 1 column & paste link by Martin [_4_]
Hello, I have several spreadsheets in a workbook with colums A to K Column 'A' DOES NOT have info in every line How would I select only the lines in column A...
September 23rd 16 05:32 PM
by Claus Busch Go to last post
1 406
SUMIF HELP by Chance224
Can you have two arguments for a SUMIF function? I want cell K56 to sum cells K3:K44 if cells A3:A44 has a value of M or W. I can it to work with just one...
8 629
New group for MIS reporting related queries and answered, please join us by XLS S
Hi All, We have created an new MIS reporting related group for all, request you all to please join us for your query / question...
September 20th 16 08:08 AM
by XLS S Go to last post
0 433
Change default settings for Comments? by Terry Pinnell[_4_]
If I add a comment to a cell using Excel 365, the default displays my name at the top, and it's also in a larger font than I'd like. How can I permanently...
September 16th 16 12:36 AM
by GS[_6_] Go to last post
5 429
Cost of each whole unit beyond by GoTeamGo4321
Hi, I am trying to do the logic on the far right en masse for a set of data, but need to find a way to always formulaically pick the whole unit(s) cost above...
September 15th 16 08:10 PM
by GoTeamGo4321 Go to last post
1 321
Amend all Macros by Jooniper
Hi all, Is there any way to change the year in all macros in a spreadsheet, or do I have to do them all individually and manually? I have a spreadsheet with...
September 14th 16 03:28 PM
by GS[_6_] Go to last post
2 327
Selec same row different column? by Terry Pinnell[_4_]
I've been trying to make a minor edit to a simple XLM macro which I wrote many years ago. On running the macro from any cell it should select the cell in col B...
September 13th 16 06:00 PM
by GS[_6_] Go to last post
9 446
Automatically Conditionally Formatting Pivot Table based on Percentages by GoTeamGo4321
Hi, I can't figure out why conditional formatting is not obeying a pretty simple set of rules to format percentages based on a scale. I have adjusted...
September 12th 16 08:18 PM
by GoTeamGo4321 Go to last post
3 367
Removing unwanted messages by Terry Pinnell[_4_]
I'm the sole user of this PC and so don't want to get messages like these. https://dl.dropboxusercontent.com/u/4019461/Excel-UnwantedMessages.jpg Can anyone...
September 11th 16 07:30 AM
by Terry Pinnell[_4_] Go to last post
1 355
Trapped in a cell! by [email protected]
I'm 14 years late to this party, but you just saved me! Thanks!!!
0 390
Can I use TMP files to recover a deleted xls file? by TShirtPrintUK
We had a disastrous accident and deleted an Excel file permanently. We still have eleven TMP files though in the same folder (with names like RT...
(Multi-page thread 1 2)
September 9th 16 05:23 PM
by hoahoihong1985 Go to last post
16 3,781
XLSM and XLSX - what's the difference? by Terry Pinnell[_4_]
Could someone please clarify the purpose of the new file types in Excel 2016/365, as I'm confused. In various web articles/posts, such as this...
September 9th 16 10:27 AM
by Terry Pinnell[_4_] Go to last post
7 399
List of multiple repeating numbers assigned unique but like valueswith a formula by GoTeamGo4321
Hi, I have a list of values listed below (actual list is hundreds of thousands of lines) that I need to read as 1, 1a, 1b, 1c, 1d, 1e, 2, 2a, 2b,...
3 330
Capital letters by Akash Maheshwari
Hi Team, How can I ensure that only capital letters are keen in specific cells of a specific sheet. Awaiting for your response. Best Regards Akash...
September 8th 16 02:19 PM
by everonvietnam2016 Go to last post
2 333
Posting A WORD Question, Please by Bob[_19_]
Hello, Couldn't find a MS WORD group, so will take the liberty of posting here, as I imagine most of you folks use both. My longer WORD documents are opening...
September 6th 16 01:54 PM
by Claus Busch Go to last post
1 326
Lost all content? by Terry Pinnell[_4_]
I was editing a worksheet. Can't say precisely what my last step was, but suddenly I have this empty, grey window. Tried various commands but so far no joy....
September 2nd 16 02:24 PM
by Terry Pinnell[_4_] Go to last post
3 397
Pasting symbol? by Terry Pinnell[_4_]
In Excel 365 I inserted some new rows and this format symbol appeared. https://dl.dropboxusercontent.com/u/4019461/Excel365-Pasting-1.jpg What exactly should...
September 1st 16 10:14 AM
by Terry Pinnell[_4_] Go to last post
2 339
Customising date format by Terry Pinnell[_4_]
After entering a date as say 2/8/16 it's easy to format it to become Tuesday 2 Aug 2016 by using 'dddd d mmmm yyyy'. But is it possible to refine dates further...
(Multi-page thread 1 2 3)
August 31st 16 02:25 PM
by Terry Pinnell[_4_] Go to last post
28 1,035
Excel cuts off bottom of page in Print Preview by Lazzmatazz
In some Excel files, especially ones received via email and then edited, the Print Preview cuts off the bottom portion (a quarter or a third) of the page....
5 2,174
1 Attachment(s) formula to calculate value based on threshold by Excel Dumbo
Friends, Please see attached file and if you could please suggest a single formula that will provide the value and two separate formula that will shows...
August 24th 16 01:37 AM
by Excel Dumbo Go to last post
4 601
Post New Thread

Display Options
Showing threads 121 to 140 of 146462
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 12:15 AM.

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