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
EXCEL averageif with different #of values to average per calculation,depending on two criteria by [email protected]
I need to take the average of a large data set, for example for the hour(C) 7 of day(B) 2, hour 8 of day 2 and so on. As you can see some hours have more data...
0 517
Excel Average of dates with different data point #s and values. by [email protected]
I need to take the average of a large data set, for example for the hour(C) 7 of day(B) 2, hour 8 of day 2 and so on. As you can see some hours have more data...
0 458
Averageif in Excel by [email protected]
I need to take the average of a large data set, for example for the hour 7 of day 2, hour 8 of day 2 and so on. As you can see some hours have more data points...
0 480
Formula to identify decimal versus whole numbers by moily
Hello, I'm using Excel 2003 and am interested in knowing a forumla that can identify decimal numbers versus whole numbers. I need to create an if forumla...
(Multi-page thread 1 2)
16 2,597
Need help with many changed Hyperlinks by PitchNinja
Hi, I was looking to see if someone could help me with a problem with hyperlinks. I have an excel file located on my desktop that I use for church on Sunday...
(Multi-page thread 1 2)
October 3rd 16 05:36 AM
by GS[_6_] Go to last post
11 1,133
Index Match with if or iferror help by [email protected]
Hello, need some help with the formula below. I need the index match to look and pull a value from different spreadsheet, however, if it comes back as error...
September 28th 16 08:01 PM
by Bạch11165 Go to last post
2 447
Opening Ribbon > Home without the alphabet soup? by Terry Pinnell[_4_]
If I click the Home button in Excel 365 I get the large Ribbon. Daunting but readable (and I need to make the effort to use it instead of always reverting to...
September 28th 16 09:55 AM
by Terry Pinnell[_4_] Go to last post
8 481
File saving messages on launching Excel by Terry Pinnell[_4_]
For some reason I'm getting these messages whenever I launch Excel 365. Presumably because I have AutoSave switched on. What's the usual quickest way of...
September 26th 16 09:24 AM
by Terry Pinnell[_4_] Go to last post
1 354
Print titles must be contiguous and complete rows or columns by [email protected]
On Thursday, June 17, 2010 at 8:20:35 AM UTC+4, tanvnit wrote: > "Print titles must be contiguous and complete rows or columns " > > solving this error : in...
0 378
2007 Excel sucks - cant freeze multiple rows & columns anymore by 2007 Excels sucks99999
Help (of course unless you know F1 anymore you cant get to help via menu either) says you can, but "menu" no longer allows option of freezing more that the...
3 2,640
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 380
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 587
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 388
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 398
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 292
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 301
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 423
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 338
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 329
Trapped in a cell! by [email protected]
I'm 14 years late to this party, but you just saved me! Thanks!!!
0 353
Post New Thread


Display Options
Showing threads 101 to 120 of 146455
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 03:28 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.