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
Formula for Cochran's Critical Values by Dave Curtis[_2_]
Hi, I'm trying to do some data analysis using Cochran's test for outlying variances. I have 4 replicate numbers from each of 20 laboratories. I calculate the...
8 3,680
Update of two cells from a cell. by luis vejarano
Hello group such good day. Do I make myself clear: A1 I have a cell that can enter values manually, for example numbers: 1, 2, 3, etc. I have the cell B1 has a...
October 6th 15 05:06 PM
by luis vejarano Go to last post
0 641
countifs and wildcards to count dates by [email protected]
Hi! I have a countifs functions which has, among other criteria, to count all the dates of a certain month and year. here the...
2 777
SUMIFS returning #DIV/0! by [email protected]
=SUMIFS(Cost_Per_Point,Build_Id,C$1&"*") Cost_Per_Point is a named range pointing at Builds!26:26 (Builds Sheet row 26) Build_Id is a named ranged pointing at...
0 607
How to calculate a "current week" when it doesn't 'start' on a Sundayor Monday? by [email protected]
I have a tracking sheet for a team whose reporting period is Thursday-to-Wednesday. I'm trying to write a function or macro that can filter all items in a list...
2 708
COUNTIF? by Malcolm Austin
I am attempting to count the number of "X" in non adjacent cells, but have had no success so far. I have recurring table for 12 people being surveyed, so...
September 18th 15 06:13 PM
by Claus Busch Go to last post
2 725
nested if function by tomtic56
Hi all, I have a spreadsheet and am trying to calculate hours worked using 2 sheets. sheet1 is entitlement calculation and sheet2 is public holidays starting...
September 15th 15 09:38 PM
by tomtic56 Go to last post
0 664
Using if in calculating hours by [email protected]
Hi... This question is part of a weekly time recording sheet. I currently have set September month. 1st 7 columns is manually entered time using formatting...
4 608
Sumifs within Offset Match by ITexcelNY
Hi I need help! I'm trying to create a sum formula using offset matches. Essentially, I want avoid using sumifs since the columns could change order, but the...
September 11th 15 10:03 AM
by Claus Busch Go to last post
2 757
sum for count formula please... by driller3_banter
I have 1 sheet with 2 columns of data I like to have 1 formula that fill-in counting parameter. C1=entry of min value to filter B3:B22 D1=entry of max value...
September 4th 15 08:17 AM
by driller3_banter Go to last post
0 697
Permanently Group Worksheets by Krysta Davis
Hi, Just wondering if it possible to permanently group worksheets and how i go about doing it. i want sheets 2 & 3 to get data from Sheet 1 but only sheet 1...
September 2nd 15 03:01 PM
by GS[_6_] Go to last post
1 820
Advanced Excel Functions Ebook by robert
any suggestion for advanced excel functions ebook if any ? thanks --...
September 1st 15 01:06 PM
by jack1090 Go to last post
2 2,159
How to add prefix to names in a column by [email protected]
I have 1000 plant names in a column I want to add the prefix "http://www.google.com/images?q=" to So "Acer Campestre" and so on...
August 30th 15 07:44 PM
by Claus Busch Go to last post
1 649
Help With SUMIF Function by tb
I have a formula that goes down col. A such that it inserts an "X" (without quotes) in the cells if a certain criteria is met in data inserted in other...
August 28th 15 07:13 PM
by tb Go to last post
2 598
need adsense account seller from USA by [email protected]
brother Please add me your skype or email me or +8801737577505, i buy many adsense account for bangladesh
1 630
count if three colums match . by [email protected]
Hi experts. i have a data like this i wanna count if continuous three zero and after this > 0 in a range if this criteria tow time in a range then output 2...
0 534
Replace #N/A via sctipt by [email protected]
Hi I am importing xml into my sheet and one of the imports is #N/A as the node being imported is a expiry date if said node does not expire the field is...
0 654
Convert Array Formulas to Regular Formulas by Domenick
I have a workbook that is linked to a query from another (legacy) application. I have formulas that do further calculations with the query results....
6 1,768
SUBTOTAL and COUNTIF (or SUMIF) combination by DKS
Hi, I would like to use the COUNTIF (or SUMIF) only for filtered rows. Thus somewhere a SUBTOTAL kind of functionality but for COUNTIF. Is it possible to...
August 15th 15 07:14 AM
by Claus Busch Go to last post
3 2,130
Can't see all text in Excel Cell by Lynz[_3_]
Fairly large amounts of text pasted into cells. All cells have text wrapped, aligned left and centred and have adjusted row height and column width but...
5 2,190
Post New Thread


Display Options
Showing threads 141 to 160 of 88499
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 11:08 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.