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
Multiplying a Number Found in an Alphanumeric String by Randomerz
I am working on a project that someone none-too-bright started. The cell that I need to update looks like this: Monkeys $233 Dogs $159 Yes, these four line...
November 15th 15 05:13 PM
by Claus Busch Go to last post
9 1,577
1 Attachment(s) stock sheet by montypython
Hi Guys I have attached a template which can be changed I need to make boms or have scenario where if I enter 10 bent spikes for powder coating, it minuses...
November 11th 15 09:24 PM
by GS[_6_] Go to last post
1 999
Number values by CP514
Hello experts, i have a huge database of entries from a survey generated from google forms into excel. long story short i have various pivot tables and...
November 11th 15 08:53 PM
by CP514 Go to last post
3 878
FREQUENCY FORMULA by rhhince[_2_]
I have this formula in Excel 2003. =MAX(FREQUENCY(IF(AM$67:AM$2001=AN4,ROW(AM$67:AM$2001)),IF(AM$67:AM$2001<>AN4,ROW(AM$67:AM$2001)))) I am trying to calculate...
November 8th 15 10:01 AM
by abmmusic4 Go to last post
3 917
1 Attachment(s) Need Help With dates and linking it by Jaddo92
Dear Team, i have an excel sheet as per the attachment below what am trying to do i need to find a way on the right there's Days Left and before i have 2...
November 7th 15 01:59 PM
by Jaddo92 Go to last post
0 835
Static date not working using VBA by Joe Clarke
I am trying to insert a static date into column P (from p7 down) if the adjacent column is populated. I need it to remain blank otherwise and the O column is a...
November 6th 15 02:26 PM
by Claus Busch Go to last post
1 838
Help With Extracting Text String by tb
I am using Excel 2013 (32-bit) on a Windows 7 PC. I am trying to extract part of a string for each part number in my file. I would like to extract the string...
November 4th 15 12:29 AM
by tb Go to last post
2 761
Conditional Formatting not working right by Christopher Jack
Hello, I have a time tracker with calculated times, then based on input of actual times the color of the time is suppose to go red if greater then the...
October 24th 15 07:03 PM
by Christopher Jack Go to last post
1 1,047
formula to switch last/first name around? by Stilla
Is there a formula I can copy into say, cell B1, that will change a name in cell A1 from "Brown, John" to John Brown? Thanks to all you excel wizards out...
October 21st 15 06:07 AM
by Claus Busch Go to last post
8 4,045
How to save random numbers? by Rangemaster
Hi folks, Hopefully someone can help me with this question - it bothers me for hours now and I can't find the answer anywhere on the WWW. I'm making an excel...
7 1,690
Converting google flights results to Excel by [email protected]
Hi, I am not sure if this is the right group to ask this question but: I want to be able to copy google flights result to excel such that price, destination,...
0 988
Help with Multiple VLOOKUPs in an IF statement by dakota park
I have a table with the top row headers (classifications) of "LOW," "MIDDLE," "MODERATE," "UPPER," & "UNKNOWN." Under each are random (identification) numbers...
October 10th 15 01:08 AM
by MyVeryOwnSelf[_3_] Go to last post
2 864
Variable Page Break by Christopher Jack
Hello, I have a table that has the date in column A. The start date is variable based on the value in O1. From there, the next cell is calculate from the one...
October 9th 15 06:29 AM
by Claus Busch Go to last post
5 907
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,873
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 752
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 898
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 706
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 799
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 827
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 760
Post New Thread

Display Options
Showing threads 141 to 160 of 88510
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:34 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.