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
Need help calculating probabilities by Kiffar
My actual dataset is much more complicated, but hopefully this simplification will do the trick. Let's say cells A1 and A2 are =randbetween(1,10), cell A3 is...
November 17th 12 03:51 PM
by Kiffar Go to last post
8 952
Unhappy
Identifying common data between 2 cells by MRPRMR
Hello- I am trying to identify common criteria between 2 cells using Excel 2007. For instance: I have a series of numbers and possibly letters in 1 cell (part...
November 17th 12 09:48 AM
by Claus Busch Go to last post
1 689
Standar deviation across sheets help by ibressler
I have written a formula that will take what is written in Column A of my Cover sheet and match it to Column A of all the other worksheets (other worksheets...
November 16th 12 11:25 PM
by ibressler Go to last post
0 395
Multiple VLOOKUP in an IF statement by Richard Doyle
Hi I want to check if a value is present across multiple worksheets So I have a list of integers in the cover sheet 1 2 3 4 5 I then want to look to see if...
November 16th 12 09:39 PM
by Claus Busch Go to last post
2 396
Evaluate Multiple Cells for any Value by Billy Daniel
If this has been covered previously I did not find it an searches. I have several cells that I need to evaluate. These cells are not side by side in columns...
November 16th 12 09:22 PM
by GS[_2_] Go to last post
1 412
Need help finding a substring in a array of strings. by hvcrios
This is driving me insane, all I want to do is check whether the information contained in a cell is present in an array of cells or not, it's substring and I'm...
November 16th 12 08:50 PM
by Claus Busch Go to last post
1 421
Validation of cell based on Drop down list by murtaza7210
I need to perform validation on column B depending on the selected dropdown value in column A.... I have column A with drop list whose value are Sales Cash,...
November 16th 12 02:55 PM
by Claus Busch Go to last post
1 358
Return Column Header from an Index/array, finding Large with a userinput date by alovell
I'm looking for the brand name of the largest sales. I have a function I can use if I know the row I am searching for, but this will change based on a user...
November 16th 12 09:32 AM
by alovell Go to last post
0 388
Scaling multiple columns by Arto Vesterbacka
Hi, I'm trying to normalize a large data set to remove errors caused by equipment. I have 101 columns (samples) that are in time order by column. These...
November 16th 12 08:19 AM
by Arto Vesterbacka Go to last post
0 341
Display yesterday's date but only for weekdays? by totalnatal
Hi, I have the following function : =TODAY()-1 The problem is that if we're monday it gives me sunday's date whereas I only want weekdays so in this case...
November 15th 12 05:43 PM
by Ron Rosenfeld[_2_] Go to last post
8 929
Formula I can't figure out by dpgreen
I know this is a strange request and it maybe difficult to do without seeing the whole spreadsheet but I am fairly new to excel and I can't make heads or tails...
November 15th 12 10:25 AM
by dpgreen Go to last post
2 433
Month Calculation by Moideen
Pls help me to get the below mentioned matter. Coloumn 1 (Invoice Date) : 05-07-2012 Coloumn 2 (Limit the Period) : 5 Coloumn 3 Need Result : 05-12-2012
November 14th 12 08:32 PM
by Moideen Go to last post
5 524
Using IF, AND and OR functions together by ahs004
Hi, I need help with using IF, AND, OR functions together. Here is my problem. I have cell C5 and E5 G5 and I5
November 14th 12 03:17 PM
by Claus Busch Go to last post
2 475
Search Text and Add a Blank Line by kojack
Hi All, New to the forum and have been searching (here and Google) for an answer with no luck. I am trying to automate the process of searching for specific...
November 13th 12 07:42 PM
by kojack Go to last post
2 468
Criteria length limit in SUMIF() by BAC
XP Pro/Office 2003 PRO Is there a limit on the number of characters that can be used in the criteria section of a SUMIF()/COUNTIF() function? Columns A & B...
(Multi-page thread 1 2)
November 12th 12 01:03 PM
by Kim_Matthijssen Go to last post
15 4,678
1 Attachment(s) Pls Help - blank cell/formula issue by Shokra
I am creating a Wages, Hour and Payroll summary for my fiancé because he's trying to keep track how the new company is handling wages/time schedules, etc. ...
November 11th 12 10:59 AM
by Claus Busch Go to last post
8 978
VLOOKUP or SUMIF for Multiple Criteria by Rob Kein
Im hoping this is possible. I am looking for a formula that will sum a large range of data in a specified column corresponding to multiple criteria that does...
2 705
Cool
Setting a range in a named range by Askjerry
Let's say I named the first column "ALPHA" and that I want to perform some function on it... If I use this... Set myRange = Range("A2",...
November 10th 12 01:29 AM
by Ron Rosenfeld[_2_] Go to last post
3 494
Help. Trying to do the opposite of VLOOKUP by Randy Sauve
I have a specific number X in a cell and in the column beside I have a list of data that ranges from smalles to largest. I need to find a number in that...
November 9th 12 10:04 PM
by plinius Go to last post
3 640
Post
1 Attachment(s) Time Zone Conversion Table by naven_sg
Hello All, Need a Help in Conversion of Time Zone. I have a table in MST Time Zone, with 30 minutes interval. The data shows how many FTE working during that...
November 9th 12 06:50 PM
by Ron Rosenfeld[_2_] Go to last post
2 433
Post New Thread


Display Options
Showing threads 1001 to 1020 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 05:28 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.