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
VLOOKUP formula by Briggs
I have two spreadsheets that I need to merge and am using a VLOOKUP formula. Sheet 1 has ID numbers in column A; Sheet 2 has ID numbers in column A, last...
November 13th 08 03:13 AM
by Sheeloo[_3_] Go to last post
3 274
Cheap Indian Chicks by JellyFish
http://warnet.ws/img2/183/dom/4.jpg http://warnet.ws/img2/183/dom/1.jpg http://warnet.ws/img2/183/dom/3.jpg http://warnet.ws/img2/183/dom/5.jpg http://warnet.ws...
November 13th 08 02:33 AM
by JellyFish Go to last post
0 300
Formula gone awry by Connie Martin
This formula was working and it no longer works: =IF(D163="Yes","",IF(VLOOKUP(C163,NIRAV,2)="","Not Scheduled",VLOOKUP(C163,NIRAV,2))) I believe it's an...
(Multi-page thread 1 2)
November 13th 08 02:16 AM
by Sheeloo[_3_] Go to last post
11 603
following the active cell address without recalc by haystack
How can I get a cell in sheet1 to display the active cell address in sheet1 at all times without having to recalc when the active cell is changed? And if...
November 13th 08 01:48 AM
by haystack Go to last post
3 760
Count how many times a phrase comes up? by Deplywrker
I need to count how many times certain phrases come up from multiple worksheets. Let me explain the problem more in detail. I have a worksheet for every day...
November 13th 08 12:52 AM
by Shane Devenshire[_2_] Go to last post
3 1,092
i need to get all matches in one column for one criteria by PERANISH
Hello dears I having datas as follows(Example) Sheet-1 Sheet-2 Col-A col-A Col-B AA-01 ...
November 13th 08 12:40 AM
by Ashish Mathur[_2_] Go to last post
2 498
sumifs, sumif with dates by Richard Manor
Workbook to report all OT (overtime) performed during FY08 within a range of date for comparison to current FY usage. Two worksheets, 'Report' and 'FY08'. ...
November 13th 08 12:19 AM
by Shane Devenshire[_2_] Go to last post
6 894
CountIF(A9:A20, B9 not equal B10, B10 not equal B11, etc.) by Red Herald
I have a sorted column of account numbers that I want to count. I don't want to count more than one occurence of an account number if it has the same work...
November 13th 08 12:11 AM
by Ashish Mathur[_2_] Go to last post
2 851
Countif with criteria by NM
Hi, I have column B which can have a,0,1,sh as its input. I have another column c which can have I,X,D,M as its input. I want to count all the "I" in column...
(Multi-page thread 1 2)
November 12th 08 11:57 PM
by Ashish Mathur[_2_] Go to last post
11 434
Count Function by Mickey
I need to be able to count an item if a key word is in a different columns. ex: Count the cells that contain "F17000" (Columns B & C) only if it is "Out of...
November 12th 08 11:55 PM
by Gary''s Student Go to last post
5 358
Conditional formatting if a cell contains a formula by tsbarr
I would like to apply conditional formatting if a cell contains a formula as opposed to an entered number. I would think that is doable somehow using a...
November 12th 08 11:54 PM
by Ashish Mathur[_2_] Go to last post
2 593
First Non-Blank Cell by FrankM
I found this formula somewhere else on these boards ... The VALUE of the last NON-BLANK cell in a COLUMN range =LOOKUP(2,1/(A1:A100<>""),A1:A100) .......
November 12th 08 11:33 PM
by Gary''s Student Go to last post
6 419
Query Wizard - Choose Columns by MichaelRobert
I hope that this is the correct list for questions on MS Query, and Query Wizard in particular. From Excel Import External Data and connecting successfully...
November 12th 08 10:55 PM
by MichaelRobert Go to last post
3 861
Solver by Alonso[_2_]
Hi everybody i'm trying that Solver finds the best way to schedule several machines I have a table with 15 rows (4-18) the machines and 21 columns for the 7...
November 12th 08 10:41 PM
by Dana DeLouis[_3_] Go to last post
4 602
Run data analysis by Papergal
I don't know if this is possible or not: I import data from a manufacturing process. Column A - Date Column B - Product Name I want to have a table that...
November 12th 08 10:30 PM
by Dana DeLouis[_3_] Go to last post
3 325
If 5th character="-" delete everything to the left otherwise do no by Mike R.
Hi - I can't seem to figure this out, I bet it is pretty easy. Can anyone assist? The text is in A1. Thanks, Mike
November 12th 08 10:00 PM
by Rick Rothstein Go to last post
6 864
Summarizing data assigned to a label by Al Davis
I have a table of information, like this one... Name Box Bag Total Red 12 8 20 Blue 3 3 6 Green 41 41 82 Red 2 19 21 Blue 16 3 19 Green 1 8 9 ...
November 12th 08 09:55 PM
by T. Valko Go to last post
2 397
how do I round a column of numbers to the nearest by Suzy
How do I round a column of numbers up or down? ei. $27.51 = $27.50 and $29.24 = $29.25?
November 12th 08 09:49 PM
by T. Valko Go to last post
3 1,355
Pivot table help by Yossy
please I want to do a calculation Individual cost/Total cost. Let say I have: A1 100 A2 20 A3 40 Total 160 Calculate for A2 = 20/160. Can I do this...
November 12th 08 08:54 PM
by Shane Devenshire[_2_] Go to last post
1 325
If Than Statement by Xfree
I was not sure on a descriptive Subject for this so I used If Than statement due to if I were using Crystal Reports that is how I would do this: I pulled...
November 12th 08 08:53 PM
by Xfree Go to last post
3 340
Post New Thread


Display Options
Showing threads 20001 to 20020 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 11:44 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.