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
Index and match if field contains specific text in it by saintsman26
Hi - hope this is clear, what I want to do is look up cell contents (text) and if that word appears in another table return a value associated with that...
November 29th 12 07:45 PM
by Claus Busch Go to last post
1 332
How do I assign "Apple" to a cell reference in this evaluate code? by [email protected]
Sub Cnt() correctly returns 16. Sub Cnt1() either Msgbox line returns 0 Option Explicit Sub Cnt() MsgBox Evaluate("SUMIF(D2:D7,""Apple"",E2:E7)") End...
2 408
NumberFormat for small non-zero numbers? by [email protected]
I have a column that subtracts two other columns and is displayed as currency. If the other two columns are "close", this column shows zero. Most of the rows...
November 26th 12 09:23 PM
by joeu2004[_2_] Go to last post
2 417
NumberFormat instead of an IF by [email protected]
I have a column with a number that is either zero, or some other number >5 In the case where it's zero, I'd like it to say "None". Can I do this with a...
2 342
Replace data to right of string problem by Jayjones
Hi guys - trying to replace or substitute data to almost right of string ie want excel to always count 5 characters from right of cell but then only replace 4...
(Multi-page thread 1 2)
November 25th 12 07:46 PM
by Claus Busch Go to last post
10 899
date & Time by naresh vadlamudi
guys, i have date & time both as hte format below: 9/1/2012 07:45:00 AM. now i need to extract only date from it into another cell. please help....
November 24th 12 10:02 AM
by Claus Busch Go to last post
1 494
Hi, Anyone please help me in counting the same values in a sheet. Example: A1=6 B1=5 C1=6 D1=4 E1=6. In F1 I should print "3" since 6 is repeated 3 times.
November 24th 12 08:11 AM
by Claus Busch Go to last post
3 447
IF statement not returning correct answer by KerriL
Hello, I am hoping someone can help me with this. Essentially, I am trying to construct an If statement that will return "OK" or "NO" based on whether one...
November 24th 12 01:59 AM
by Ron Rosenfeld[_2_] Go to last post
4 740
Protect and Edit Object by [email protected]
When I protect a worksheet I normally check the Edit Objects box along with other items. More often than not when I unprotect the sheet to edit it and then go...
November 23rd 12 06:14 PM
by GS[_2_] Go to last post
1 481
1 Attachment(s) Multiple If statements, Calculating quarterly % holding costs by mitchellqwerty
Hi Guys/Girls I am trying to assign %'s for a Property Holding Cost. I cannot formulate the correct IF statements to correctly calculate the below-mentioned...
November 23rd 12 04:19 AM
by mitchellqwerty Go to last post
0 478
sorting noncontiguous data with exceptions by al drah
I have imported vcf files into excel 2003 and the column looks like this: BEGIN:VCARD VERSION:3.0 N: (some data) FN: (some data) MN: (some...
November 22nd 12 12:55 PM
by plinius Go to last post
3 660
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 09:53 PM
by Drea17 Go to last post
3 2,394
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 433
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 05:31 PM
by matgriffey Go to last post
0 453
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 12:14 PM
by Living the Dream Go to last post
1 469
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 08:12 AM
by Claus Busch Go to last post
1 371
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 04:15 PM
by Spencer101 Go to last post
1 419
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 08:56 AM
by preto Go to last post
0 406
Bitwise Functions? by [email protected]
Пʼятниця, 6 вересня 2002 р. 22:40:07 UTC+3 користувач John Avitt написав: > I want to do bitwise comparisons in Excel...
0 374
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 02:51 PM
by Kiffar Go to last post
8 1,066
Post New Thread

Display Options
Showing threads 1001 to 1020 of 88523
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 01:30 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.