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
Make a product that works by msnyc07
Truly you should be ashamed of Excel. I couldn't even BEGIN to itemize or describe the utter hell of working with this application and the literally 1000s...
(Multi-page thread 1 2)
February 11th, 2010 02:34 AM
by msnyc07 Go to last post
12 291
User controlled Freeze Pane while protected by FredL
Hi, I have a worksheet where it is protected and locked. Is there anyway to code there such that the user (who cannot unlock the sheet) can still use the...
February 11th, 2010 02:02 AM
by Gord Dibben Go to last post
3 114
Drop down box issue by - pat
Hey all, I am using excel 2007 on XP Professional SP2. I am using a drop down box on a worksheet that selects from a column of designated data elsewhere on...
February 11th, 2010 01:18 AM
by Ashish Mathur[_2_] Go to last post
2 158
Text to Columns by LeisaA
500+ sentences, I need to seperate (text to columns) after the first "-" only. There are subsequent "-" but I only want it seperated at the first. And when...
February 11th, 2010 01:17 AM
by Fred Smith[_4_] Go to last post
4 90
Finding duplicates by Louja
How do I write a formula that looks at two columns and looks for duplicate values in both, and flags the row if it finds them in? See below example I would...
February 11th, 2010 01:10 AM
by Ashish Mathur[_2_] Go to last post
2 82
Date format problems after csv import by YY san.[_2_]
Dear all Excel expert, I am facing 2 date problems after importing from a sql database via .csv. This field is a date + time field. Appreciate any help....
February 11th, 2010 12:36 AM
by Ashish Mathur[_2_] Go to last post
1 120
Concatenate numbers and text while holding a custom number format. by jpowell111
I want to join the values of two cells with different formatting. Example: "E3" = NPL and "O3" is a number 48.29548562458 formatted to appear 48+29. I want to...
February 11th, 2010 12:22 AM
by Ashish Mathur[_2_] Go to last post
9 135
Array Formula by Andri
Dear Experts, Please find the following formula =LARGE(IF(AND(AC.TR.NMT="X1234"),AC.STATUS=1),AC.DATE,0),1). how to make the result (AND(AC.TR,NMT =...
February 10th, 2010 10:21 PM
by Bernd P Go to last post
3 94
Lookup by Joe
How do I have Excel return multiple values from a lookup in a table of information? For example, if I have excel do a vlookup or an index/match to the input...
February 10th, 2010 09:38 PM
by Luke M Go to last post
1 116
Switched up to Excel 2007 lost functionality in my array equations by Flcnmech
Okay, I have a dataset that I have a program datamine and produce the required information into an Excel worksheet. Was using the .xls worksheet, but with...
February 10th, 2010 09:30 PM
by Flcnmech Go to last post
0 88
Solar cells for less than 1 USD per Watt by ..[_2_]
Do you know that you can find solar cells for less than 1 USD per Watt on www.ebay.com ? Regards.
February 10th, 2010 09:28 PM
by ..[_2_] Go to last post
0 143
Nested COUNTIF? by Astro
Currently, I have this worksheet with the following datas: Items Accepted Date Apple 1 30-Jan-08 Mango ...
(Multi-page thread 1 2)
February 10th, 2010 08:04 PM
by Fred Smith[_4_] Go to last post
15 222
Too Many IF Statements Nesting Error (Excel Formula Loop w/o VBA) by retailmessiah[_2_]
Hello Excel Problem Gurus, First of all, let me thank you in advance. I find it exemplary that you all can devote time to helping others who are having issues...
February 10th, 2010 07:52 PM
by Fred Smith[_4_] Go to last post
7 150
Change How Tab Operates by RH
Somehow, I've changed how my Tab Operates in Excel. How can I change back to when I hit Tab, it simply moves over one column?
February 10th, 2010 07:43 PM
by Gord Dibben Go to last post
2 123
Cell Color Recognition and Summing of Data Within a Specified Colo by Universal Pegasus - Chad
I've tried SUMIFS to recognize cell colors and add the numbers (which are hours worked in the day) in the corresponding row. The kicker is the yellow cell...
February 10th, 2010 07:20 PM
by Bob Phillips[_3_] Go to last post
1 168
Why wont my right click functions work? by purplewolf
I can not copy, paste, merge cells, or anything else with a right click. How do I change these settings.
February 10th, 2010 07:12 PM
by Teethless mama Go to last post
1 102
How do I multiply ALL CELL in spreadsheet at once by .5 ? by ariel
I am trying to multiply all the cells in my spreadsheet by .5 . each cell has a differant value but need to multiply by .5 to update. Can I do the whole...
February 10th, 2010 07:08 PM
by Fred Smith[_4_] Go to last post
2 159
Conditional Formatting with Partial name search by Diane
Is there a way to use conditional formatting to search two lists of names, and highlight the differences by only highlighing those with last name...
February 10th, 2010 06:50 PM
by Diane Go to last post
2 102
Offset with scrollbar by H.G. Lamy
Hello, I'm trying to use a (form control) scrollbar on a worksheet to cycle through a vertical (column) list of 12 month (January - December). The length /...
February 10th, 2010 06:38 PM
by T. Valko Go to last post
5 91
formula to subtract from inventory total by Dee
Hello, I would like to set up a spreadsheet where I have a call with a total number of paqs that I have in inventory. I have a column called Units where I...
February 10th, 2010 06:38 PM
by Teethless mama Go to last post
1 93
Post New Thread


Display Options
Showing threads 3061 to 3080 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 09:09 AM.


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