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
create popup message by Ann
my mind is totally not working right now. i want to create a popup message when someone clicks on a particular cell. i know this can be done with data,...
November 13th 08 05:43 AM
by Razak Go to last post
6 991
transfer data cell from another work sheet by MDAM
I want to input a value in one cell and get the info from another cell in another worksheet, eg I put 1234 it will give a name associate with that number
November 13th 08 04:12 AM
by Ashish Mathur[_2_] Go to last post
2 601
Indian sucks` by Mango `
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 04:03 AM
by Mango ` Go to last post
0 301
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 290
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 324
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 623
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 775
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,116
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 514
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 920
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 873
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 465
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 376
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 607
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 454
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 888
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 658
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 349
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 897
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 421
Post New Thread


Display Options
Showing threads 20001 to 20020 of 88519
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 03:28 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.