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 Worksheet Functions Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
Randomly Select and Assigning a Class Schedule to records. by Gene Haines
Our company requires all employees to take Mandatory Annual Courses. There are 30 courses. I have been tasked with streamlining the Class Schedule. I created...
April 22nd 17 10:07 PM
by Gene Haines Go to last post
0 115
How do I sum up random cells by Josh W
I want to add up the values of various discontiguous cells in a worksheet e.g. A2+A7+C4+D7+G3. What is the quickest way to do this? The autosum function...
(Multi-page thread 1 2 3)
24 10,139
split range address into individual cell addresses by noname
hi, Given a range say, "A1:E1", i need a formula to return a string of cells "A1","B1","C1","D1","E1". I do not want to use helper columns. has anyone tried...
(Multi-page thread 1 2)
10 1,421
Problems with Match function by [email protected]
I have used the match function many times for various reasons, but have recently encountered a problem that I cannot get passed. I have a list of values that...
April 7th 17 07:32 AM
by gmail_gia_re Go to last post
1 166
formula that copies the formula of a cell in a diffrent spreadsheet. by [email protected]
What I want is a master spreadsheet that I can update and have other 'satellite' spreadsheets copy the cell formula not the result of the corrisponding cell of...
0 132
Combine sheets into one by Eva
Hi I have three sheets called:"Matched",Unmatched", "Other" with the same columns and headings. I need to combine all in one sheet called "Data All" I think I...
(Multi-page thread 1 2)
April 4th 17 09:26 PM
by GS[_6_] Go to last post
17 467
Looking for BOOLEAN ALGEBRA functions (specifically XOR) by RL Jones
I am looking for BOOLEAN Algebra Functions. Can't find any help in EXCEL. While I can work around the OR, AND, and NOT, I need XOR.
(Multi-page thread 1 2)
March 24th 17 07:33 AM
by Auric__ Go to last post
12 1,147
Working Time Night Shifts by Jonahs
Hi I am new to this forum but desperately need help. I am creating a time sheet, and cannot find a solution to calculate the duration of time worked on a...
March 20th 17 12:59 PM
by Jonahs Go to last post
0 176
Create a conditional formula that results in another calculation by dyrret
I'm just learning to use Excel. I want to enter data in either column A (litres) OR column B (US gallons). Column C will convert to imperial gallons. I...
(Multi-page thread 1 2)
March 19th 17 09:34 PM
by JIMMYT Go to last post
11 1,846
Fill cells automatically when cleared by R0nald
Hello all, Is there any way cells get automatically populated with certain value when cleared or made empty? Example, Value to put on empty cells: 1234 A1...
March 15th 17 07:56 PM
by R0nald Go to last post
5 355
Sum Product Matrix by Phycodes
Hi all, Trying to get a formula to return the following: Column A: Title Column B: Salary 1 Column C: Salary 2 Column D: Salary 3 Column E: Salary 4
March 14th 17 01:12 AM
by Phycodes Go to last post
1 190
Floating cell with running total across multiple sheets by [email protected]
Hi everyone, I have multiple clients that I keep time sheets for using Google Sheets. I am contracted for a certain number of hours per fortnight. However,...
March 13th 17 08:26 PM
by GS[_6_] Go to last post
2 164
Linear weighted regression by [email protected]
Hi Jerry, If I want to do a linear regression with 1/x weighting, how do I calculate the weights for the X data and Y data? Thanks, Baylye
March 6th 17 07:49 PM
by Auric__ Go to last post
1 280
Removing #N/A from formula results by Holly
Hi All, Is there a way to remove #N/A as a result from a formula, for example to return a blank or zero result instead? -- Cheers, Holly
March 4th 17 01:28 PM
by Roger Govier[_11_] Go to last post
8 3,927
VLOOKUP questions by Auric__
I replaced this formula: =IF(AE16="v",IF(AG16="w",-5.5,-0.5),IF(AE16="ns",-0.5,IF(OR(AE16="x", ...
March 3rd 17 03:44 PM
by GS[_6_] Go to last post
5 280
Retreiving records from closed workbook by Håkan Björkström
I run a small company and have a large number of customers. I have made all customer related stuff in Excel (e.g. Invoices). Those are divided into separate...
February 20th 17 02:49 PM
by Håkan Björkström Go to last post
0 336
Shaded cells won't print shaded by Linda C
On screen cells are shaded, but on print preview and printing, they are not. Somone else created this spreadsheet, so I dont' know what she did to it. Without...
February 19th 17 11:41 PM
by Leigh-Anne Go to last post
3 6,570
Request for a Research Paper by [email protected]
Dear All, Please forward me the paper titled "The Role of Household-Level Characteristics in Predicting the Unbanked in Rural India: A Comparison of Eastern...
February 14th 17 07:14 AM
by Auric__ Go to last post
1 362
Excel Help! Multiplication Formula With A Max And Min Value by NGOULD
Good afternoon everyone! :-) I have been stuck trying to create a formula for my spreadsheet and was praying that someone could help me. I have spent hours on...
February 3rd 17 04:34 PM
by Roger Govier[_11_] Go to last post
5 578
quick annualization by billyk81
Is there any formula built into excel 2016 for quick annualization? Or do I have to go into every cell every month to update the formula for the given month...
February 2nd 17 11:18 PM
by billyk81 Go to last post
0 313
Post New Thread

Display Options
Showing threads 1 to 20 of 88519
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 05:24 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.