A Microsoft Office (Excel, Word) forum. OfficeFrustration

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 » OfficeFrustration forum » Microsoft Excel
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Post New Thread
Threads in Forum : Worksheet Functions Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
Formula to count duplicates by Jane
I have a list of names in a column. Some names are duplicated. I want to keep the duplicated names but I also want to count how many times the names are...
April 22nd, 2009 03:46 PM
by Jane Go to last post
6 67
Pull cell contents from one wksh to another if condition is met by Susan
Need to pull info from wkst 2, column3 and have it in entered in column 5, wkst 1 only if contents of column 1 match. Any ideas?
April 22nd, 2009 03:41 PM
by Eduardo Go to last post
3 78
combobox listfillrange network by Helmut
How can I make a listfillrange look up a range in a LAN i.e. \\filesrv\data\book1.xlsx {rangename}
April 22nd, 2009 03:27 PM
by Helmut Go to last post
0 87
Automatic add & subtract by BadBoy
Hello all, I had such great success with my last question that I am going to attempt one last question which will save me plenty of headaches if answered. I...
April 22nd, 2009 03:25 PM
by BadBoy Go to last post
0 63
Logging information by SPISO
I am new to the depth of excel but am excited to begin navigating through it. Could someone help me with the following questions. I sure would appreciate...
April 22nd, 2009 02:16 PM
by SPISO Go to last post
0 63
LOOKUP returning wrong values by Raghavendran
Hi, I am using Microsoft Excel 2004 for mac version 11.3.5 I encounter strange problem of LOOKUP returning incorrect results. Following is the simplified...
April 22nd, 2009 02:15 PM
by Raghavendran Go to last post
2 88
Track Changes- Working Partially by Peter
Hi, I came across a few cases where I am unable to track changes if I open the file for the second time. example: I get a workbook and I go ahead and...
April 22nd, 2009 12:41 PM
by Peter Go to last post
0 84
Link to another workbook path issue by CraigKer
I have 2 excel 2003 workbooks with links to a common workbook. In one of the two files the path portion of the link appears to be set to the path of the...
April 22nd, 2009 11:58 AM
by Dougal Everingham Go to last post
1 71
close match by [email protected]
Hi All, I have two sheets ( sheet1 and sheet2) Sheet1 Col A has Client name ( unique ) - Approximately 20,000 Rows Sheet 2 Col A has Client name and Col B...
April 22nd, 2009 11:57 AM
by [email protected] Go to last post
0 74
How do I convert 1000 to One Thousand (i.e numberic to words)? by Ratan Tilak
I want to convert numeric values such as "1000" to figures in word as "One thousand".
April 22nd, 2009 11:32 AM
by Bob Phillips[_2_] Go to last post
2 89
unique entry sum by Gareth.Evans
sorry first post had bad formatting Thankyou for everyone's help yesterday it was great. I have one last thing that is bafaling me to do with the same...
April 22nd, 2009 11:17 AM
by Gareth.Evans Go to last post
0 75
Sum if unique and another criteria by Gareth.Evans
Thankyou for everyone's help yesterday it was great. I have one last thing that is bafaling me to do with the same thing. I have a column in D that shows the...
April 22nd, 2009 10:31 AM
by Gareth.Evans Go to last post
0 65
insert and copy by Darius
Hi there; I need to insert a row between row 4 and 5 and then jump 5 rows further and do it again (insert row between row 9 and 10) again 5 jumps and insert...
April 22nd, 2009 08:45 AM
by Jarek Kujawa[_2_] Go to last post
3 60
how do i open an ods file in excel? by JIREH
I am trying to open an ods file in excel. how can i do this?
April 22nd, 2009 08:17 AM
by AnimalMagic Go to last post
2 101
IF Function and pulling data across by Ivan Koh
Hi would like to find out, what should the formula be like if i wanted to pull data from cell 1 from worksheet A to worksheet B if data from cell 2 of...
April 22nd, 2009 08:08 AM
by Stefi Go to last post
3 90
disable brian baulsom's worksheet change based on cell value. by jat
i am using the following worksheet change code in cell L5: Private Sub Worksheet_Change(ByVal Target As...
April 22nd, 2009 07:16 AM
by OssieMac Go to last post
2 82
INDEX MIN function? by MrRJ
Hello, I am thinking of using INDEX function, but not quite sure how to approach it. Here is my sample data. I need to produce the last column with a...
April 22nd, 2009 06:39 AM
by Bernd P Go to last post
6 81
Forumals not showing correct result (unless edit and enter) by Dannn78
Hi, Hoping someone could explain and help. I have a spreasheet with data in 3 colums and i'm try to add a formula but for some reason everytime i put the...
April 22nd, 2009 05:56 AM
by T. Valko Go to last post
1 84
Viewing of protected locked or unlocked cells by jmisenar
Is there a way to view an entire workshees to see which cells are locked and unlocked? -- Jan
April 22nd, 2009 04:58 AM
by Gord Dibben Go to last post
2 72
TURN OFF AUTO-HIGHLITE by smd1227
Hello. After selecting & deleting multiple rows in a worksheet. Excel automatically highlights the next rows in the quantityI originally deleted. This is...
April 22nd, 2009 04:50 AM
by Gord Dibben Go to last post
1 70
Post New Thread


Display Options
Showing threads 11901 to 11920 of 87787
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 Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 03:37 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.