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
Automatically copying data from sheet1 to sheet2 by Ria Ray
Hello! I am new to Excel and am stuck with an issue. I will be thankful if any one could shine some light on the issue. I have 2 excel sheets: sheet1 :...
5 3,071
Display feet inches and fraction by Homer
I would like to be able to input 11 3 1/2 and have the cell display as 11'-3 1/2" Is this possible?
(Multi-page thread 1 2)
10 2,436
How to handle this logic test by Terry Pinnell[_4_]
I really am rusty! Could someone please remind me how to enter a function in col B that will return different strings depending on the content of col A. Like...
February 10th 16 09:09 AM
by Terry Pinnell[_4_] Go to last post
7 694
Need formula to increase Alpha character to next letter by pwinters
I am looking for a formula that will increase by one letter the alpha designation in a column. ex. A2 would be the letter 'A', B2 which would show the next...
February 6th 16 08:57 PM
by greencounter Go to last post
4 25,562
Averaging feet and inches (not decimal feet) by Cory Boyd
I am a H.S. Track coach in charge of throwing events. I am trying to put together a spreadsheet that will average my athlete's results throughout the season...
February 5th 16 05:33 PM
by GS[_6_] Go to last post
7 1,328
Trendline Not Showing ? by Bob[_19_]
Hello, Using Excel 2007 and W10. Have a very simple two column spreadsheet. Dates in one column, and numeric value in the other column. Dates are formatted...
February 4th 16 04:06 PM
by Bob[_19_] Go to last post
0 551
Help!! I am trying to delete a toolbar (avery) by bvealey
I have and use the Avery Wizard. However, when I open Excel, Word, or Outlook it automatically appears in the toolbar section. I have deleted it over and...
(Multi-page thread 1 2)
16 2,307
Sr. Citizen With A Few Basic Charting Questions, Please by Bob[_19_]
Hello, Am trying to create a chart, and notice that when I click on a charted data point that shows up, I see, e.g.: 6-Oct, 75 Can't imagine what the 75...
February 3rd 16 01:54 PM
by Bob[_19_] Go to last post
0 448
Lookup unique cell with date and time combined by Excel Dumbo
Hi Friends, I have attached a spread sheet. I would need to lookup a cell with unique value of date and time combined and then labelling them...
February 2nd 16 08:37 AM
by Claus Busch Go to last post
1 534
Exclamation
Count the number of times a cell has been up-dated by Lionel.Rose
Using Excel 10 I have a total spreadsheet with a total which is updated via a template. What I would like to do is count the number of times the total...
February 2nd 16 12:45 AM
by Lionel.Rose Go to last post
0 496
Excel is turning entered dates into formulas despite format. Why? by Matt Mahan
I have a worksheet that turns all numbers with an operator into a formula. For instance when I enter "4/11/06" it changes it to "=4/11/06". This is regardless...
January 28th 16 10:25 PM
by ben.hauber Go to last post
2 1,548
Sr. Citizen (Very) With WORD Question, Please (I know an Excel Group,but...) by Bob[_19_]
Hello, I know this isn't a word GROUP, BUT I can't seem to find an active group for WORD. Will blame my ignorance on my age now. I figured you folks would...
January 27th 16 01:39 PM
by Bob[_19_] Go to last post
2 535
Unable to freeze panes by [email protected]
Another mystery with Excel 2010. I have an existing spreadsheet in which I had frozen first column and top row. The freeze has disappeared and I cannot...
(Multi-page thread 1 2)
18 2,160
Remove borders, keep grid-lines by Michael Graubart
I am using Excel 2008 on a Mac desktop computer with OS 10.8.5. I added a border to a certain row of cells (a black line underneath the row) in a spreadsheet,...
January 21st 16 04:51 PM
by Michael Graubart Go to last post
2 702
Unhappy
when adding a column the answer turns to zero by Julia Strupiechowska
when i try to sum a column up the answer turns to zero. I think this is because it think that the figures are text however im unable to change them back to...
January 20th 16 05:55 PM
by Claus Busch Go to last post
2 596
Extract IP address from... by [email protected]
Hello All, I am trying to extract the IP address from the following: Capsuletech: 10E-PICU Rm 10-436 Bed 20 10.102.42.213 ping Capsuletech: 10E-PICU Rm 10-434...
January 19th 16 04:08 PM
by Jim Harris Go to last post
2 608
Counting Coloured Cells - Conditional Formatting by Victor Delta[_2_]
Hi I'm using Excel 2003 and have a range of cells whose colour is determined by conditional formatting. Does anyone please know if there is a way to count...
January 16th 16 01:27 PM
by Victor Delta[_2_] Go to last post
4 629
Conditional Formatting with multiple sheets and VLookup/Offset by Phrank
Hi. I posted this to the WorksheetFunctions group first, but then I noticed there were only about 6000 posts in that group, so I'm posting it here in hopes of...
January 11th 16 10:48 AM
by nhocbb82 Go to last post
3 1,138
Help to deciper the String Extraction formula by [email protected]
Found this, but need help to decipher the formula ========================================== * returns the characters between the 3rd and 4th underscores...
1 855
Conditional Subtotal with data table by Sarah H.[_2_]
Hi, guys, I am using data tables in Excel 2010 for Windows. I have this formula: =SUBTOTAL(102,Table2) I want the subtotal to be conditioned on whether...
January 7th 16 05:15 PM
by Sarah H.[_2_] Go to last post
4 787
Post New Thread


Display Options
Showing threads 201 to 220 of 146451
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 02:50 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.