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
Copy Pivot column from one Sheet to Another by [email protected]
Hi, I have the following vba command which copies the Pivot Data to another sheet, however I need to be more specific. I need to copy individual columns,...
2 578
Nested IF AND returning #VALUE! by Paul Doucette
I have what I thought was a simple formula I wanted to return a value based on the condition (TRUE or FALSE) of two cells. They are either both true, both...
(Multi-page thread 1 2)
July 9th 16 07:37 PM
by Paul Doucette Go to last post
11 957
I'm trying to use COUNTIFS to count how many times someone attendedtutoring, but in a data range such as 4-9 or 2-3 by [email protected]
I am using Countif to see how many people that attended one time got A's and that worked as =COUNTIFS(C36:C65,"1",B36:B65,"a") And when it came to attendance...
July 7th 16 08:24 PM
by Claus Busch Go to last post
1 587
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)
36 4,358
Calculate Interest that compounds every 3 Years by AdmiralAJ
I'm working on a trying to set up a formula for services where the cost increases 6% every 3 years over the next 15 years. The standard FV function doesn't...
June 29th 16 06:43 PM
by AdmiralAJ Go to last post
0 596
Edit & Paste link help by Martin [_4_]
Hello, I have 16 spredsheets with people like this who are Communicants G . McCormick Mr & Mrs J. John & Grace Address Town Postcode D. McCarley Mr & Mrs...
June 26th 16 11:29 AM
by Martin [_4_] Go to last post
0 564
combining MIN and MAX formulas... by DUV
I have a situation where i need the result to be constrained between two numbers . I can do the bottom and top constraints individually but cannot figure out...
June 24th 16 11:11 PM
by GS[_6_] Go to last post
5 730
How do I set a maximum value (e.g. cap at 200) by LeeLobb
I have a formula set to multiply a rate by a quantity, I then need to cap the total at 200 example: 42 people x 86 minutes x $0.05 = $180.60 but I need the...
June 24th 16 03:04 PM
by DUV Go to last post
7 37,968
Using the IF and VLOOKUP Function to calculate the tax rates and tax deducted by nerrawsl
I need to calculate the federal tax rate. The federal tax rate is a function of the adjusted income and the employee's marital status. Reference the tax tables...
June 14th 16 03:53 AM
by GS[_6_] Go to last post
3 2,162
Need formula to test if cell is a multiple of 28, but not including 28 by Wazzel
I have successfully used =IF(MOD(G3,28)=0 to identify whether my cell value is a multiple of 28, but I need for it to exclude 28 itself. The very simple...
June 10th 16 09:38 PM
by Wazzel Go to last post
4 1,111
left, search mid by [email protected]
Hello I have a spreadsheet send to me and the only thing I need to do is extract 2 numbers 1. I need to extract numbers between the first( )to one cell then...
June 7th 16 08:02 PM
by Claus Busch Go to last post
3 1,068
HOW DO I SEPERATE POSITIVE AND NEGATIVE VALUES FROM A COLUMN by FRANK
I HAVE A COLUMN OF FIGURES I WISH TO MAKE TWO MORE COLUMNS ONE SHOWING POSITIVE VALUES ONE SHOWING NEGATIVE VALUES
June 5th 16 05:56 AM
by Deb_z Go to last post
6 4,128
Countifs between a certain value by [email protected]
HI I need to count the values between a set value, and then only show how many times this count was more than 5. The values counted is variable only the...
June 3rd 16 09:29 PM
by Claus Busch Go to last post
3 870
Need Formula For Extracting Part Numbers by tb
I am using Excel 2010 for Windows. I have a database of part numbers like this one: 10_32M2A050A002 CYLINDER Please note that there are two blank spaces...
May 31st 16 10:57 PM
by tb Go to last post
3 923
Index / Match with condition by b_nuruddin
Part 1 I have a spreadsheet with two tabs. In the first tab (Sites) I want to populate column B with a "Y" or "N" based on whether or not the site exists in...
May 31st 16 06:22 PM
by b_nuruddin Go to last post
2 1,051
Using the Time function with an IF statement by Allison Mazurek
HI - I was hoping someone could help me with a time function. =IF(W2=$B$2,IF($Z$2>TIME(11,30,0),'Current Day Balances'!$B$4-'Current Day...
May 31st 16 06:07 PM
by Claus Busch Go to last post
5 904
1 Attachment(s) Formula to get the dynnamic date of the month by shiva_reshs
Hello, I have several reports that I need to send to several people on certain days of the month. So to avoid the last minute preparation, I prepare the...
May 31st 16 05:24 PM
by Claus Busch Go to last post
1 851
Dupes in a range by L. Howard
How can I make this formula respond ONLY to two-digit values in a range? (Array Entered) =IF(MAX(COUNTIF(Data1,Data1))>1,"Y","N") Where the values may also...
May 29th 16 10:58 PM
by GS[_6_] Go to last post
7 962
Join two functions by b_nuruddin
I have two if(and(or statements that work separately but cant figure out how to join them together into one. Is there a way to join or re-write the following...
May 27th 16 07:07 PM
by b_nuruddin Go to last post
2 909
Convert QuickBooks time format to excel to calculate by Misty May
When I export a Quickbooks "Time by Job Summary" report to Excel, the time is converted in a time and date format. If I want to put a dollar amount to that...
3 1,921
Post New Thread


Display Options
Showing threads 81 to 100 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 02:35 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.