column News and Other Resources

Q&A

How to sum up data with dynamic selection using formula in Excel?

October 15, 2012 1:28am PDT

How to sum up data with dynamic selection using formula in Excel? Hello all, How to sum up the data with dynamic selection using formula in Excel? For example: In row 1, I wanted sum up...

1 Latest comment by Stephen Lam

Q&A

Can I insert multiple columns in between multiple columns in Excel?

September 24, 2012 4:17pm PDT

Can I insert multiple columns in between multiple columns in Excel? I have 75 columns but I want to insert two additional columns between each one. Can I do that with one or two commands?

1 Latest comment by carola@...

Q&A

How to separate out dates in excel?

July 24, 2012 9:02am PDT

How to separate out dates in excel? I have dates from 2008 - 2015 in one column and want to group them in date order, how do I write the formula? Sort or filter Hi, If you just want them listed...

3 Latest comment by grandmistress

Q&A

Transposing an Array of data into a single column in Excel

July 11, 2012 4:12am PDT

Transposing an Array of data into a single column in Excel I have a bunch of data which is spread into an Excel sheet spanning 24 columns and abut 1000 rows. For each of the 1000 rows I need all...

2 Started by Shriks | Latest comment by jladen@...

Q&A

Remove duplicates in column "A" and add theyre values in column "B"

June 26, 2012 5:30am PDT

Remove duplicates in column "A" and add theyre values in column "B" I have a list of part numbers in excel, that all have more than one time associated with each one. i would like to remove all...

1 Latest comment by waynesiterlet

Q&A

How to delete rows and columns only if rows &/columns are entirely blank?

June 14, 2012 1:01am PDT

How to delete rows and columns only if rows &/columns are entirely blank? if i am using "go to special" and select "blank" even the rows & / columns which are having data except in 1 cells are...

7 Latest comment by financetech

Q&A

How can you create and maintain a column of historical peak scores in Excel

May 15, 2012 8:51am PDT

How can you create and maintain a column of historical peak scores in Excel I have a spreadsheet in the form of a matrix. Each row represents a client and each column represents a different...

2 Started by martin.peirson@... | Latest comment by Al Kostiuk

Q&A

Highlight Cell When Already input Text with Condional Formatting

May 7, 2012 5:55am PDT

Highlight Cell When Already input Text with Condional Formatting I Have make the table game like Tic Tac Toe ("O" & "X" ) in 15 rows and 15 column , the rule to win is to make 5 by rows, column,...

1 Latest comment by phisop

Q&A

excel 2007

March 1, 2012 4:23am PST

excel 2007 hi i want to compare sheets in one excel 2007 file for duplicate names to see if there are any, how do i do this anyone??? try a formula what you can do within a worksheet is to first...

4 Started by sallydj | Latest comment by Al Kostiuk

Q&A

T-SQL: How to Select Rows By Certain Sum of a Column?

January 31, 2012 12:54pm PST

T-SQL: How to Select Rows By Certain Sum of a Column? Hi everyone. I have a table named as Questions with 3 columns(Id int, Question_Text varchar(200), Question_Points tinyint). I need to select...

5 Latest comment by StojanMk

Q&A

FRx Column Type Issue?

December 22, 2011 6:52am PST

FRx Column Type Issue? Using FRx release 6.7.10343 on a Windows 2003 SP2 32-bit server. Some of our reports use the FRx Forecaster column type, however this morning our accounting users looked at...

1 Latest comment by Charvell

Q&A

sql query

November 27, 2011 10:02pm PST

sql query hi i want to retrieve only that columns whose value is not null can anyone help me what will be the query in sql server 2005 for retrieving that columns Request for Clarification Just...

2 Started by aena | Latest comment by PiratePrasad

Q&A

Word 2007 table numbering question.

October 18, 2011 9:58pm PDT

Word 2007 table numbering question. I have a HUGE very complicated table going over many pages. The document is a set of instructions shown in columns and space for recording data in the...

1 Latest comment by odearmassr@...

Q&A

What is the Formula for calculating cumulative/progressive data in excel?

August 2, 2011 8:22am PDT

What is the Formula for calculating cumulative/progressive data in excel? I want to have one sheet where I will put the daily sales data, so that progressive data will be automatically be...

6 Latest comment by suniltr77@...

Q&A

Excel column headings

July 28, 2011 9:29am PDT

Excel column headings I want to use as column headings the values in the first row of my file. I know this is possible, but I have forgotten how to do it. I am working in Excel 2007 home. The Help...

3 Latest comment by john.a.wills@...

Q&A

In Excel how can I add data to an existing cell?

July 13, 2011 11:09am PDT

In Excel how can I add data to an existing cell? I have a row of cells that have a truncated zip code. For some reason this system truncates preceeding zeroes. I need a formula that will allow me...

7 Started by Georgem5 | Latest comment by brian_meahan - TechToolBox.com

Q&A

How can I move data from 1 xls worksheet to a 2nd (records not all same)?

April 17, 2011 12:40pm PDT

How can I move data from 1 xls worksheet to a 2nd (records not all same)? I have data on one spreadsheet, I'd like to add to another. EXAMPLE: Record ID's 1 2 3 4 5 exist on one worksheet, with...

3 Started by mikef42 | Latest comment by oldbaritone

Q&A

Populate text boxes based on 2 combo boxes?

April 1, 2011 6:48am PDT

Populate text boxes based on 2 combo boxes? Using ACCESS 2007, I have two combo boxes. The first lists all the Tables in the data base. Each table is a contract where I record monthly costs. Based...

1 Latest comment by mwisejay

Q&A

How do I repeat an =If then else function down a column

March 30, 2011 9:50am PDT

How do I repeat an =If then else function down a column I have a spreadsheet for keeping scores in a local sports league. In cell A1 I have the number of league points for the match and in B1 I...

5 Latest comment by the.gnome

Q&A

How do I get a SharePoint new column's data to show up in the task?

March 28, 2011 5:00pm PDT

How do I get a SharePoint new column's data to show up in the task? When viewing the SharePoint tasks within Outlook, a new column added within SharePoint does not appear in Outlook. Outlook only...

1 Latest comment by MStG