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
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 09:37 AM
by Claus Busch Go to last post
1 505
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 01:45 AM
by Lionel.Rose Go to last post
0 460
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 11:25 PM
by ben.hauber Go to last post
2 1,507
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 02:39 PM
by Bob[_19_] Go to last post
2 507
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,099
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 05:51 PM
by Michael Graubart Go to last post
2 654
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 06:55 PM
by Claus Busch Go to last post
2 554
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 05:08 PM
by Jim Harris Go to last post
2 561
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 02:27 PM
by Victor Delta[_2_] Go to last post
4 586
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 11:48 AM
by nhocbb82 Go to last post
3 1,062
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 800
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 06:15 PM
by Sarah H.[_2_] Go to last post
4 735
Excel changes not saved, then show up by exg
I had a user with a weird problem with Excel 2003 on Windows 7 (new laptop he just got) He was working on several Excel documents all day, and saving his work...
January 6th 16 08:48 PM
by exg Go to last post
0 577
help adding and subtracting stones and pounds by [email protected]
Thank you, thank you, thank you!!!! This is amazing, I have been trawling the internet for something like this and this is the simplest and most efficient...
1 1,833
Help Required (19th Dec 2015) by Akash Maheshwari
Hi Team, Can someone help me with a code. I have one sheet with the name as Go_To. In this sheet I have dates mentioned from 1st Jan to 31st Dec. I have one...
December 24th 15 12:08 PM
by Pankaj Sharma[_2_] Go to last post
2 862
1 Attachment(s) Group expense splitting by Excel Dumbo
Hi, Using the public forums , I managed to partly build up a file that helps to split costs among friends. But I will need further help completing this. Please...
December 17th 15 10:43 PM
by Excel Dumbo Go to last post
2 726
Page break preview has thrown a wobbly by Martin [_4_]
Helo, Page break preview will not let me adjust the margins properly Each tile I drag the margins to where I want It ends up with what looks like a page for...
December 17th 15 05:38 PM
by Martin [_4_] Go to last post
0 707
Convert visa pdf statements to three columns in excel? by imogen b
hi, I would like to download data from a pdf visa statement into an excel spreadsheet. (My visa company will only download three months of statements into...
December 16th 15 09:13 PM
by Claus Busch Go to last post
2 736
Help Required - 11th Dec 2015 by Akash Maheshwari
Hi Team, I have two Columns. Column A is for Email ID & Column B is Mobile No. What I want is if I try to enter any duplicate email id in Column A then...
December 10th 15 09:17 PM
by Claus Busch Go to last post
3 789
Help Required 9th Dec 2015 by Akash Maheshwari
Hi Team, Greetings!! Require a solution. I have used a Rank Formlua which displays 1-8 Ranks. if 1 is displayed it should reflect 1st in the cell if 2 is...
December 9th 15 07:36 PM
by Akash Maheshwari Go to last post
2 764
Post New Thread


Display Options
Showing threads 201 to 220 of 146447
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:29 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.