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
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 986
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 106
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,724
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 263
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 114
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 107
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 188
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,821
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 205
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 256
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,379
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 290
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 474
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 226
bar code scanning w/spaces by [email protected]
I've been trying to figure this out for a while, played with it - gave up for a while, but now I need to figure this out. In Excel 2007 using a Font called 3...
February 2nd 17 07:11 PM
by GS[_6_] Go to last post
1 251
Thumbs up
Calculating combinations by Beddy Boy
Hi, New user to this forum so hope I'm in right place.. I am trying to set up an excel spreadsheet when I can calculate the odds for a number of...
February 1st 17 04:47 AM
by Beddy Boy Go to last post
0 296
Problem With formula by tb
I have built this formula in cell Y4 which is used to calculate...
January 31st 17 12:04 AM
by tb Go to last post
2 270
automatically putting in dates like tuesday/thursday by [email protected]
On Thursday, May 15, 2003 at 5:53:39 AM UTC-7, John wrote: > or Monday Wednesday... > > if i enter a date in one cell and then drag the cell it > will want...
0 303
Thumbs up
Training Tracking by Irodeludo
Hi, I am pulling my hair out as the formulas on our training tracker were messed up. I have googled and tried everything that it said, but it just didn't...
January 26th 17 09:17 AM
by Irodeludo Go to last post
2 281
Conditional Formatting- highight entire row by nmb
Good morning. I have a spreadsheet with conditional formatting in it. It is almost performing as I want. However, I can not figure out how to make a rule apply...
January 20th 17 04:33 PM
by Claus Busch Go to last post
1 294
Post New Thread

Display Options
Showing threads 1 to 20 of 88516
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:02 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.