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
Merging Columns by Titanium
I am trying to 'make one' a number of columns... Essentially I have several thousand rows of data that I need to clean up... What I would like to accomplish is...
(Multi-page thread 1 2)
May 31st, 2010 09:36 PM
by vhnbvb Go to last post
13 854
Date Formula 85 factor by Newfie809
Hi A1 September 1, 2010 Years of Services Age A2 B2 C2 ...
May 31st, 2010 07:38 PM
by Newfie809 Go to last post
0 513
Lose the 0 in the Total cell by Malcolm
I’m using the formula below, in a worksheet to count cells containing the letter S. My problem is in the total cell, it displays a 0 until I enter an S in...
May 31st, 2010 06:58 PM
by Malcolm Go to last post
6 484
Showing known cell reference in a popup by Colin Hayes
HI I'm trying to show a selected cell reference in a popup , rather than the cell content. This is the code : Dim lrow As Long With ActiveSheet ...
May 31st, 2010 04:19 PM
by Colin Hayes Go to last post
4 460
File placement with copied sheets by AE[_2_]
I have a spread sheet built that currently has 382 sheets of data. The sheets are 12 columns x 61 rows. There are conditional formats applied. I can copy a...
May 31st, 2010 03:04 PM
by Mike H Go to last post
1 427
sheet name in workshhetfunction by Radhakant Panigrahi
Hi , I am using the sheet reference in a formula. the sheets are named on the basis of dates of a month... So i have to change the formula in every month...
May 31st, 2010 02:55 PM
by Mike H Go to last post
2 558
Count number of people by burtlake
We will be hosting a large fund raiser. I need to know the number of people attending. Here's my problem................ Some people come as couples, and...
May 31st, 2010 02:15 PM
by Bernard Liengme Go to last post
4 547
Remove non-space spaces? by msnyc07
I have a large spreadhsheet with data I've manually copied/pasted from various sources including web pages. As I am trying to do things like import to Mysql...
May 31st, 2010 02:06 PM
by Bernard Liengme Go to last post
3 582
Vlookup from different sheets by Radhakant Panigrahi
hi, I have the below data...like this i have huge data in different sheets(which are named date wise) and i can not consolidate them in a single sheet as the...
May 31st, 2010 01:38 PM
by Radhakant Panigrahi Go to last post
2 745
Using a Text Cell to Reference a Worksheet Name by Jay L
I have one summary worksheet and approximately 45 data worksheets. Each row on the summary page needs 8 - 10 cells from each data worksheet. The...
May 31st, 2010 12:26 PM
by Roger Govier[_8_] Go to last post
7 765
Excel formula to incrementally increase a value by 1 every 365 day by ScheduleMyAppointmentNow_Com
I need help with correct formula to take a starting date from one cell and place a formula in another cell that will increase the number by one for every 365...
May 31st, 2010 06:54 AM
by Max Go to last post
2 586
Find & replace different years (part of the date)in a column by krishna K
I have the various dates on which our staff have joined the organisation. I need a column that would convert all the year part of the date into the current...
May 31st, 2010 06:32 AM
by Jacob Skaria Go to last post
1 480
Need Help with Sumif Function including dates by KDenise
Hi, I need some assistance with tracking my commissions that are due to be paid each month. The "Comm Due Date" is in column "C", rows 3 - 30 which list by...
May 31st, 2010 04:47 AM
by Max Go to last post
6 965
Using a COUNTIF statement with an AND operator by JTurner
I'm using Excel 2003 so I hope I'm not limited here. We are performing a space usage survey and I need to compile the data results. Each location has 70...
May 31st, 2010 04:29 AM
by Ashish Mathur[_2_] Go to last post
4 495
Linking Equations to Highlights by Q
I am interested in linking a formula to the colour of the cell. Ie. positive number would produce a green cell & negative cell would high light the cell in...
May 31st, 2010 02:28 AM
by Ashish Mathur[_2_] Go to last post
2 495
Yes - No Interactive Text Box by DisMusBeDaPlaz[_2_]
Working in Excel, I am looking for help using interactive fill-in check boxes. I am creating a form. Setting up a cell or a bunch of cells merged, or not...
May 31st, 2010 12:41 AM
by Normek Go to last post
1 525
Source and Destination worksheet difference by Malcolm
I am using this formula to enter text into a column of cells of the source worksheet and the corresponding column of cells in the destination worksheet;...
May 31st, 2010 12:16 AM
by Malcolm Go to last post
5 471
moving multiple data in a cell to other columns by Joan in DC
I imported a spreadsheet. One column contains multiple data lines that I want to put into separate columns. They are consistent in their presentation. How...
May 30th, 2010 09:26 PM
by Gord Dibben Go to last post
1 398
How to find a value with multi-column, multi-record list by Dallasm
I have a spreadsheet with $costs arranged according to values in both rows and columns. How do I create drop down lists for both the rows and columns and then...
May 30th, 2010 05:40 PM
by T. Valko Go to last post
1 513
Help needed urgently by AndyW
Hi, Im trying to check that one row of data satifies a criteria, then if it does it counts an entry in another column adjescent to it. Example: - Column A...
May 30th, 2010 05:07 PM
by T. Valko Go to last post
4 433
Post New Thread

Display Options
Showing threads 161 to 180 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 08:55 PM.

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