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
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 01:59 PM
by Jonahs Go to last post
0 73
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 10:34 PM
by JIMMYT Go to last post
11 1,699
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 08:56 PM
by R0nald Go to last post
5 242
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 02:12 AM
by Phycodes Go to last post
1 94
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 09:26 PM
by GS[_6_] Go to last post
2 87
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 08:49 PM
by Auric__ Go to last post
1 164
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 02:28 PM
by Roger Govier[_11_] Go to last post
8 3,798
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 04:44 PM
by GS[_6_] Go to last post
5 190
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 03:49 PM
by Håkan Björkström Go to last post
0 242
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 20th 17 12:41 AM
by Leigh-Anne Go to last post
3 6,321
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 08:14 AM
by Auric__ Go to last post
1 279
Exclamation
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 05:34 PM
by Roger Govier[_11_] Go to last post
5 458
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 3rd 17 12:18 AM
by billyk81 Go to last post
0 211
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 08:11 PM
by GS[_6_] Go to last post
1 233
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 05:47 AM
by Beddy Boy Go to last post
0 279
Problem With formula by tb
I have built this formula in cell Y4 which is used to calculate...
January 31st 17 01:04 AM
by tb Go to last post
2 255
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 286
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 10:17 AM
by Irodeludo Go to last post
2 265
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 05:33 PM
by Claus Busch Go to last post
1 276
Exclamation
2 Attachment(s) Sort Data into new spreadsheet based on cell value by Nat96173
Hi all I am stumped on this one. I need to create a new spreadsheet based on the main data spreadsheet (see attached example). I need to sort based on a...
January 20th 17 12:24 AM
by Nat96173 Go to last post
0 329
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 12:55 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.