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
1 Attachment(s) Finding most recent date for each customer - XL 2007 by Geoff B
I have a simple list, the left column is the customer number, the right column is the date of every sale made to the customer. I need to filter this list to...
November 21st 12 10:53 PM
by Drea17 Go to last post
3 2,343
Matching two columns of data by JFLaj
Hi All, I have two columns of numbers that need to be kept as pairs for example; 122 505 122 909 345 6576 555 676 I need to randomly choose a pair x amount...
2 399
1 Attachment(s) Lookup Formula Assistance by matgriffey
Good morning I have posted other requests and been given help so hope someone can help me decipher this question. The goal I am trying to accomplish is having...
November 21st 12 06:31 PM
by matgriffey Go to last post
0 424
Simplifying multiple IF statements? by rgbiernat
Hi there, In U3 I have this working formula: =IF(B3=("Y");'System details'!E7)+IF(C3=("Y");'System details'!E14)+IF(D3=("Y");'System...
November 21st 12 01:14 PM
by Living the Dream Go to last post
1 444
1 Attachment(s) return a value depending on two previous values by petschek
Hi all, I have three different people providing a service (translations). Each person has three different rates depending on the type of translation (normal,...
November 21st 12 09:12 AM
by Claus Busch Go to last post
1 340
IF/AND/OR Statements by gmannix1000
Hi Guys, Trying to figure this out, wondering if anyone could help me. I have three conditions with four different variables each, I'll describe...
November 20th 12 05:15 PM
by Spencer101 Go to last post
1 388
1 Attachment(s) Calculating the change in lead times from a table. by preto
Hello, I've been struggling with the following problem for a couple of hours now and have the distinct feeling that it could be solved by a simple formula. I...
November 20th 12 09:56 AM
by preto Go to last post
0 376
Bitwise Functions? by [email protected]
Пʼятниця, 6 вересня 2002 р. 22:40:07 UTC+3 користувач John Avitt написав: > I want to do bitwise comparisons in Excel...
0 326
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 989
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 716
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 418
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 414
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 432
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 440
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 376
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 420
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 356
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 953
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 455
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 542
Post New Thread

Display Options
Showing threads 1001 to 1020 of 88516
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:54 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.