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
Formula in excel by Rhianne
I have a rather large personnel spreadsheet which I am collating every employee's details into, a similar but less extensive and recent spreadsheet had a...
November 13th 08 11:10 AM
by Pete_UK Go to last post
3 270
VLOOKUP for this problem? by Zakynthos
I have an employee's name in cell A5 on a SS called Repair rotas.xls on the Plymouth Staff tab. The Saturday rota for this employee, called 'Saturday C', is...
November 13th 08 10:14 AM
by Zakynthos Go to last post
4 368
Change format of a date field by Sageman
I have been given a csv file - on opening in excel the dates are in the format 25051917, 5051949, 23121979 etc. I have been struggling to get them into the...
November 13th 08 09:24 AM
by Ashish Mathur[_2_] Go to last post
7 350
SUMPRODUCT won't work on a row by PFB
The following formula works on a column range (A1:A40), but not on a row range (A10:U10). What have I missd? ...
November 13th 08 08:42 AM
by Bob Phillips[_3_] Go to last post
5 640
Find numbers lower / further than the previous (Track & Field) by Mal/Betty
I'm new to Office 2007, so am a little vaig on what to do. I'm trying to automate a Recod of Events (Times/ Distances) in Ecxell but can not get it to do...
November 13th 08 06:35 AM
by Shane Devenshire[_2_] Go to last post
2 364
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 1,007
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 612
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 316
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 302
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 340
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 640
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 783
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,131
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 532
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 938
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 883
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 494
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 387
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 624
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 480
Post New Thread


Display Options
Showing threads 20001 to 20020 of 88524
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:07 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.