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
Counting months in a filtered list by DerekE
I need to be able to count months in a filtered list I know this wont work but it will give you an idea of what I am trying to...
4 93
How can I count items in a filtered list? by Counting filtered data.
I have an excel spread sheet table that I filter. I would like to be able to count the number of cells in the filtered data. Anyone know how to do this? CountA...
(Multi-page thread 1 2 3 ... Last Page)
37 4,594
I have a spreadsheet for clothing order for a group of people. There are 8 different shirt types (tee, hoodie, etc.) and 10 different sizes available. I want...
2 231
Inverse of COUNTIF?? by [email protected]
Hi Jason, I'd like to know what formula should i use if i have to copy the text or value from 1 sheet to another with this specific date.
0 147
Combining data from several sheets by Jooniper
Good morning all, I am trying to combine data from 4 tabs into 1, but only where data exists. Basically, I have 4 sheets of information that pulls from...
May 3rd 17 10:00 AM
by Jooniper Go to last post
0 117
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 197
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,507
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,542
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 235
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 200
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 571
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,271
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 241
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,978
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 436
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 256
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 226
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 347
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 4,017
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 364
Post New Thread

Display Options
Showing threads 1 to 20 of 88523
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 01:33 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.