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
GETPIVOTDATA #REF! error XL2003/2010 by Paul Martin - Melbourne, Australia
Hi, I have a GETPIVOTDATA formula that worked fine in XL2003 and now that I've opened it up (some time later) in XL2010, I'm getting a REF error. Are there...
February 26th 13 08:13 AM
by Paul Martin - Melbourne, Australia Go to last post
1 357
Date Conditional Formatting by Excel Dumbo
Hello, I need a formula to help in doing conditional formatting for date say for Example- Date given is 25/02/2012 When this date has only one month left to...
February 26th 13 03:23 AM
by GS[_2_] Go to last post
1 318
Formula Question by Digital2k10
Del Figured it out.
February 25th 13 02:18 PM
by Digital2k10 Go to last post
0 303
Using Auto filtered Data by alfredosos
Dear All, Some help on this would be greatly appreciated. I have a column of text data (Column B). I would like this text data to be rolled up in to a...
February 24th 13 07:39 PM
by alfredosos Go to last post
0 353
U*nexplained ribbon change by [email protected]
When I installed Excel 2010, I found Home > Styles > Cell style presented me with default cell colors for four types of cells: Normal, Good, Bad,...
(Multi-page thread 1 2)
10 456
1 Attachment(s) Data Validation List by murugavelmsc
HI Experts, A B C D 101 ABC NO In D column i have a data validation i'e if c1="No", "NA", count(A1, B1)>=2 and D2>=DATE(2013,1,1),D2<=DATE(2014,12,31) ...
February 23rd 13 04:53 PM
by shanermuls Go to last post
3 400
Rounding dollar amounts to the 9 cents by SugarMagnolia
I have a column of dollar amounts that I need to round up or down so that every amount ends in a nine (ex: $23.43 becomes $23.39 and $56.77 becomes $56.79). ...
February 23rd 13 11:47 AM
by shanermuls Go to last post
2 260
1 Attachment(s) Changing Monthly Data to Daily Data? by thenewbigmack
Hey everyone... had a question and hoping this won't be too hard to achieve. I have a weather worksheet which is in daily format (1/1/1950), but I have a new...
February 23rd 13 10:51 AM
by shanermuls Go to last post
1 431
Question
Add image in forum by AMosand
Hi. I'm new to forums, and I don't know how to add an image in the post I am going to make. Can someone explain it to me?
1 297
Add numbers if cell fill is a certain color; How To? by Kirk Bubul[_2_]
Being old, I keep a spreadsheet of all medical events and their eventual payments to medical providers. This year we have one major category of outgo with...
February 22nd 13 08:56 PM
by Kirk Bubul[_2_] Go to last post
5 739
February 21st 13 11:30 AM
by elissmith27 Go to last post
2 1,131
1 Attachment(s) Permanently link formula references to Column Names and not Column Cell Numbers by Excel Dumbo
Hello, I have a formula in which the references are cell numbers. I would like to permanently link the references to column names, so when i add/delete...
February 21st 13 03:23 AM
by GS[_2_] Go to last post
1 492
Additional columns for Pivot table by Excel Dumbo
Hello Attached is a pivot table with multiple consolidation ranges. I would like to insert two additional columns names them Growth (2012 over 2011) and...
February 20th 13 08:54 PM
by Excel Dumbo Go to last post
1 447
Need urgent help with excel formula by zeeshanbutt
Hello All, I need a excel formula. Please see the excel data, formula rules, and expected result from this...
February 20th 13 04:44 PM
by zeeshanbutt Go to last post
1 434
1 Attachment(s) Formual to lookup sumtotal from data with spaces by Excel Dumbo
Hello, Please refer attached file and advise Formual to lookup sumtotal from data with spaces. Thanks Excel Dumbo
February 19th 13 11:27 PM
by Excel Dumbo Go to last post
2 380
To remove #DIV error by Excel Dumbo
Hi , Please refer the file stored in the link below and advise the mistake i have made in the formula. I am getting a #DIV error. I would like it to appear as...
February 19th 13 11:26 PM
by Excel Dumbo Go to last post
3 438
Question
1 Attachment(s) Formula for percentage calculation by Sabir
i have values 0-5000 i want to add percentage to the value as follows less than 100 - 25% 100-300 -20% 300-400 -15% 400-500 -10% 500-600 ...
February 19th 13 07:59 AM
by Claus Busch Go to last post
2 395
1 Attachment(s) Look UP using 3 conditions by Excel Dumbo
Hello, Please refer the attached worksheet and kindly suggest a look up formula using three conditions. I am having trouble attachingthe file on to this...
February 18th 13 04:41 AM
by Excel Dumbo Go to last post
4 660
Using the If function for a date range by Jon Keym
Hi, I was wondering if anyone could please help me. I'm trying to set up a formular that says if A1 (which is a date) is between 01/01/2012-31/12/12 then B1...
February 15th 13 11:29 PM
by johnhy Go to last post
4 580
I would like to input a time without the seconds showing by Tara
I have tried to format the cell by using both general and time formats. When using h:mm AM/PM the seconds till show up. I am using this for a mail merge...
February 15th 13 07:49 PM
by bocaei Go to last post
5 4,718
Post New Thread


Display Options
Showing threads 1001 to 1020 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 10:39 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.