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
vlookup_surya_siva by surya and siva[_2_]
COL A COl B COL C COL D COL E/exptcd Hypothyroidism Leg pains ...
June 10th, 2009 02:22 PM
by Teethless mama Go to last post
3 114
Remove hyperlink, web link, and using Advanced filter by roger
For using of Ms excel; 1. When using copy “1” and pastespecial, select “multiply” on the cell that contain web or java script hyperlink, the...
June 10th, 2009 01:52 PM
by Pete_UK Go to last post
1 113
index function - ascending order by willemeulen[_38_]
I'm using the index function to lookup data from the web (web query). Curently I'm using 4 web query's to update information (set to refresh on opening the...
June 10th, 2009 01:36 PM
by JLatham Go to last post
1 135
Pivot table - deducting sub-totals of income and expenditure by DRW
In Excel 2007, I use pivot tables to analyse income and expenditure. I would like to be able to deduct the expenditure from the income, but Excel seems to...
June 10th, 2009 01:20 PM
by DRW Go to last post
4 234
Time Calculations and Conditional Formating by kristy_6278
How can I identify if I have double booked an employee into a workshop and I’ve scheduled them at the exhibition booth? Do I use conditional formatting?,...
June 10th, 2009 01:11 PM
by Eduardo Go to last post
1 170
Search between dates & return other column by sonic-the-mouse
I am looking to solve the following problem Col A Col B Col C Col D Date received Date Processed Days taken Are days...
June 10th, 2009 01:06 PM
by David Biddulph Go to last post
9 329
Can I set AutoFit to Excel cels by Value increases with increase in font.[_2_]
I have reduced the text size in an Excell work sheet. Is it possible to reduce the cell size to suit the text size.
June 10th, 2009 12:46 PM
by Jacob Skaria Go to last post
1 166
Help with MATCH function by FJ
Hi, I need help with a MATCH formula. I have three columns, A, B, and C. I am entering the formula in column D. I want to look up data in column C and see...
June 10th, 2009 07:11 AM
by FJ Go to last post
6 161
Working with 2 arguments over 4 columns (countif ??) by Dubbo
I am trying to determine a formula for this DATA A B C D 1 Team 1 Team 2 Ump 1 ...
June 10th, 2009 05:36 AM
by Shane Devenshire[_3_] Go to last post
2 118
=SUM(IF help please by kristap
I'm helping my husband do a spreadsheet for work, and last time I had a question I came here and I got much needed help but that was a while ago and now I'm...
June 10th, 2009 04:41 AM
by T. Valko Go to last post
5 126
Conditional Formatting & Data Validation? by kristy_6278
I have a couple of questions, I am managing 100 volunteers at a conference in Florida and they need to be assigned to sessions/workshops and an exhibition...
June 10th, 2009 04:08 AM
by Max Go to last post
1 109
sumproduct/sum not working with multiple variables by Nelson
I am using this formula which works well if I am only trying to match 1 part number...
(Multi-page thread 1 2)
June 10th, 2009 03:49 AM
by Teethless mama Go to last post
10 193
Setting cell selections in form spreadsheet by kentuckyjo
I am trying to get my tab button to jump to the unlocked cells only so that the user can go straight to the cells that they need to populate on my form...
June 10th, 2009 03:27 AM
by Gord Dibben Go to last post
1 127
remove duplicate rows but keeping all columns by DC
I have several columns of information (i.e addresses) and one of the columns has duplicate numbers. I want to remove the duplicates rows and retain the...
June 10th, 2009 03:10 AM
by Gord Dibben Go to last post
3 160
Locking Worksheets, Copy and Paste Question by Philip
Hi, I would appreciate any help you can give with my following question. I am trying to lock different sections within a worksheet, and I am wondering if...
June 10th, 2009 03:09 AM
by Gord Dibben Go to last post
3 157
If_Then question by Giovanna
I have a workbook with different sheets within the workbook. On my code page I have a column with client, client code I have assigned to each client. I...
June 10th, 2009 02:56 AM
by Jacob Skaria Go to last post
1 188
Vlookup from another tab by H
Hi, I was wondeirng if anyone can help me. Is it possible to have a vlookup be a part of an IF statement? In my Column L I need it to check in another tab...
June 10th, 2009 02:38 AM
by Jacob Skaria Go to last post
2 330
How do I turn on the automatic date function by Dave
I want excel to automatically add the current date in a cell.
June 10th, 2009 02:30 AM
by Jacob Skaria Go to last post
3 137
Past due function by nannybears
I have 4 columns with a name (Joe Customer), due date (5/10/09), promise pmt date (5/20/09), days past due (10). Can I do this with conditional formatting...
June 10th, 2009 01:14 AM
by nannybears Go to last post
5 129
Helo there - Help with showing deviation (+/-) from a set number... by [email protected]
I am attempting to set one cell (R6C20) as a value, a second cell (R9C20) as a number and then have a third cell (R12C20) display the deviation of (R6C20) from...
June 10th, 2009 01:04 AM
by [email protected] Go to last post
2 100
Post New Thread


Display Options
Showing threads 10261 to 10280 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 02:20 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.