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
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 252
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 422
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 288
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 733
February 21st 13 11:30 AM
by elissmith27 Go to last post
2 1,112
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 484
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 439
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 424
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 365
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 426
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 386
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 647
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 569
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,693
Conditional Format Entire Workbook by Popdaddylee
When selecting the first worksheet and holding down the shift key and selecting the last worksheet in the unprotected workbook, the conditional format is not...
February 15th 13 03:53 PM
by GS[_2_] Go to last post
1 679
Formula Help by tj123001
I am trying to get this formula to work. =IF($B$2="",SUMIFS('Revenue Data'!$E$2:$E$2426,'Revenue Data'!$N$2:$N$2426,'Total Summary'!$B21,'Revenue...
February 15th 13 12:22 PM
by Stan Brown Go to last post
2 294
Moving Average by Prets
Hi everyone, I have been given a project to do but am a little stumped and hoping someone could give me some assistance/advice. We have several sites and...
February 15th 13 10:43 AM
by Prets Go to last post
0 330
Start sheet in a workbook by Stuart[_32_]
I use Excel 2010. In one workbook, which I use frequently, I always want to open at the same sheet. I found a setting in Options once and it worked fine but...
February 15th 13 10:23 AM
by Stuart[_32_] Go to last post
2 322
Excel date formate doesn't change by jennifer barclift
Export data from Servce manager ams1 sm9 create csv fle want to change the format to mm/dd/yyyy mm:hh. tred several seneros 21/01/2013 10:45:37 21/01/2013...
February 14th 13 04:35 PM
by jennifer barclift Go to last post
0 391
lookup 2 columns, return value from third by slezgus
I have two tables of pretty much the same format. Column A shows a name that may or may not be repeated a few times, while column B shows one of four values...
February 14th 13 04:11 PM
by vba_n00b_CA Go to last post
3 3,093
Post New Thread

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