Keep Text to Column format in Excel 2007
We’re wondering if there is a way to get Excel 2007 to remember the previous Text to Column settings. We are receiving reports in an email that we copy into Excel. We run the Text to Column>Delimited>Delimiters (Only Other = |)(Text Qualifier left as default = *)>Column Data Format (General). Every thing works great and [...]
Answer Question
| May 2, 2011 9:00 PM
Excel 2007, Excel 2007 functions, Excel functions
We’re wondering if there is a way to get Excel 2007 to remember the previous Text to Column settings. We are receiving reports in an email that we copy into Excel. We run the Text to Column>Delimited>Delimiters (Only Other = |)(Text Qualifier left as default = *)>Column Data Format (General). Every thing works great and [...]
Answer Question
| May 2, 2011 9:00 PM
Excel 2007, Excel 2007 functions, Excel functions
Why does my COUNTIF for the middle row not come up with the right counts?
Why does my COUNTIF for the middle tow not come up with the right counts? The first on and last one are OK, but they only have one condition. =COUNTIF(D6:D38,”<30″) ‘ — OK =COUNTIF(D6:D38,”<60″)-COUNTIF(D6:D38,”>29″) ‘ — counts double? =COUNTIF(D6:D38,”<=89″)-COUNTIF(D6:D38,”>=60″) ‘ — counts double? =COUNTIF(D:D,”>90″) ‘ — OK
Answer Question
| January 20, 2011 4:00 PM
COUNTIF statement, Excel formulas, Excel functions
Why does my COUNTIF for the middle tow not come up with the right counts? The first on and last one are OK, but they only have one condition. =COUNTIF(D6:D38,”<30″) ‘ — OK =COUNTIF(D6:D38,”<60″)-COUNTIF(D6:D38,”>29″) ‘ — counts double? =COUNTIF(D6:D38,”<=89″)-COUNTIF(D6:D38,”>=60″) ‘ — counts double? =COUNTIF(D:D,”>90″) ‘ — OK
Answer Question
| January 20, 2011 4:00 PM
COUNTIF statement, Excel formulas, Excel functions
How can I retrieve an Excel file saved in Hotmail?
I opened an excel attachment in hotmail and started editing, i saved it continuously but when I closed excel and reopened the file was gone… i;m running office 2007 and win 7 64bit
Answer Question
| October 23, 2011 5:32 PM
excel, Excel functions, Hotmail, Windows, Windows 7 64-bit
I opened an excel attachment in hotmail and started editing, i saved it continuously but when I closed excel and reopened the file was gone… i;m running office 2007 and win 7 64bit
Answer Question
| October 23, 2011 5:32 PM
excel, Excel functions, Hotmail, Windows, Windows 7 64-bit
Search for column header in Excel 2007
I use a macro for a weekly report. In the macro i use “Column (“C:C”).Select to select that column to filter out the zeros. Sometimes the information is in a different column when the data is downloaded, but the header of the column is still the same: “90_day_Late”. How do i search for “90_day_Late” (say it [...]
Answer Question
| November 25, 2010 3:42 AM
Excel 2007, Excel 2007 functions, Excel 2007 macros, Excel functions, Excel macros
I use a macro for a weekly report. In the macro i use “Column (“C:C”).Select to select that column to filter out the zeros. Sometimes the information is in a different column when the data is downloaded, but the header of the column is still the same: “90_day_Late”. How do i search for “90_day_Late” (say it [...]
Answer Question
| November 25, 2010 3:42 AM
Excel 2007, Excel 2007 functions, Excel 2007 macros, Excel functions, Excel macros
Sending Excel 2007 spreadsheet without calculations
I want to save a copy of my spreadsheet to send to someone, without them seeing my calculations. I need to convert the equation, save the answers as they appear in number format. I know there is an easy step but can’t find the terms to search it properly. (Excel) Can someone please assist me?
Answer Question
| November 12, 2010 6:38 PM
Excel 2007, Excel 2007 functions, Excel 2007 workbooks, Excel functions
I want to save a copy of my spreadsheet to send to someone, without them seeing my calculations. I need to convert the equation, save the answers as they appear in number format. I know there is an easy step but can’t find the terms to search it properly. (Excel) Can someone please assist me?
Answer Question
| November 12, 2010 6:38 PM
Excel 2007, Excel 2007 functions, Excel 2007 workbooks, Excel functions
Is there a standard formula for counting highlighted cells in Excel 2007?
Is there a formula for when you highlight some data cells, for use of simply counting rows, that Excel will give you the count of those cells as the answer on another sheet in the workbook- just by highlighting? But this is based on highlighting random cells in a column every day, never the same [...]
Answer Question
| June 6, 2012 3:20 AM
Excel 2007, Excel 2007 functions, Excel 2007 workbooks, Excel Database, Excel functions
Is there a formula for when you highlight some data cells, for use of simply counting rows, that Excel will give you the count of those cells as the answer on another sheet in the workbook- just by highlighting? But this is based on highlighting random cells in a column every day, never the same [...]
Answer Question
| June 6, 2012 3:20 AM
Excel 2007, Excel 2007 functions, Excel 2007 workbooks, Excel Database, Excel functions
How to collapse data in a Pivot Table in Excel 2007?
I created a Pivot Table and its giving me a description with the different codes that fall under each I want to collaspe all the descriptions so that the codes under each disappear and are summed up within each description I can do them one at a time but I have some many lines to [...]
Answer Question
| December 13, 2010 5:38 PM
Excel 2007, Excel 2007 functions, Excel 2007 workbooks, Excel Forms, Excel functions, PivotTable
I created a Pivot Table and its giving me a description with the different codes that fall under each I want to collaspe all the descriptions so that the codes under each disappear and are summed up within each description I can do them one at a time but I have some many lines to [...]
Answer Question
| December 13, 2010 5:38 PM
Excel 2007, Excel 2007 functions, Excel 2007 workbooks, Excel Forms, Excel functions, PivotTable
Edit-Find Excel 2003
I prepared an Excel 2003 file containing about 10 spreadsheets for a company whose name appeared in the spreadsheets. The sheets contain confidential information about the company the file was sent to. I now wish to send this file to others having deleted the name of the original company for reasons of confidentiality with the [...]
Answer Question
| October 30, 2010 12:24 PM
Excel 2003, Excel 2003 functions, Excel functions, Excel worksheets, Windows XP
I prepared an Excel 2003 file containing about 10 spreadsheets for a company whose name appeared in the spreadsheets. The sheets contain confidential information about the company the file was sent to. I now wish to send this file to others having deleted the name of the original company for reasons of confidentiality with the [...]
Answer Question
| October 30, 2010 12:24 PM
Excel 2003, Excel 2003 functions, Excel functions, Excel worksheets, Windows XP
Inserting Hex values into Excel
Im new to Excel and am trying to Concatenate a number of cells together and sperate them by a single character represented by a Hex “4F”. The combined cells will then be written to a file on my PCs C drive by way of a script. I will Transfer the file to a Mainframe PDS. [...]
Answer Question
| November 10, 2010 9:51 PM
Concatenate, excel, Excel formulas, Excel functions, Hexadecimal values
Im new to Excel and am trying to Concatenate a number of cells together and sperate them by a single character represented by a Hex “4F”. The combined cells will then be written to a file on my PCs C drive by way of a script. I will Transfer the file to a Mainframe PDS. [...]
Answer Question
| November 10, 2010 9:51 PM
Concatenate, excel, Excel formulas, Excel functions, Hexadecimal values
View row labels as column headings when scrolling in Excel 2007
Row 1 contains the column labels, when scrolling the A, B C column headings are replaced with the row names. It is not “freeze” situation.
Answer Question
| October 4, 2010 5:57 PM
Excel 2007, Excel 2007 functions, Excel 2007 workbooks, Excel functions
Row 1 contains the column labels, when scrolling the A, B C column headings are replaced with the row names. It is not “freeze” situation.
Answer Question
| October 4, 2010 5:57 PM
Excel 2007, Excel 2007 functions, Excel 2007 workbooks, Excel functions
Pulling information from one spreadsheet into another spreadsheet.
We have two spreadsheets created and spreadsheet b has referenced totals from certain columns from spreadsheet a. The problem is that the spreadsheets are maintaned by 2 different people. And throughout the day spreadsheet a gets new information added to it, how can this information be brought into spreadsheet b without closing and reopening spreadsheet [...]
Answer Question
| October 4, 2010 7:19 PM
Excel 2003, Excel 2003 functions, Excel functions, Excel worksheets
We have two spreadsheets created and spreadsheet b has referenced totals from certain columns from spreadsheet a. The problem is that the spreadsheets are maintaned by 2 different people. And throughout the day spreadsheet a gets new information added to it, how can this information be brought into spreadsheet b without closing and reopening spreadsheet [...]
Answer Question
| October 4, 2010 7:19 PM
Excel 2003, Excel 2003 functions, Excel functions, Excel worksheets
How do I disable save/save as and control +s and f12 in excel 2007?
I want o disable those and only allow save feature through the macro I established
Answer Question
| October 1, 2010 7:10 PM
Excel 2007, Excel 2007 functions, Excel functions, Office 2007
I want o disable those and only allow save feature through the macro I established
Answer Question
| October 1, 2010 7:10 PM
Excel 2007, Excel 2007 functions, Excel functions, Office 2007
Merging Excel or CSV file to Active Directory
How can I automatically add users email addresses to their active directory profile? Their email address is their first initial followed by their last name at our domain dot com. I can create an excel or csv file with the data necessary but how can I merge it into AD?
Answer Question
| September 8, 2010 1:32 PM
Active Directory, Active Directory migration, CSV, CSV file format, Excel functions
How can I automatically add users email addresses to their active directory profile? Their email address is their first initial followed by their last name at our domain dot com. I can create an excel or csv file with the data necessary but how can I merge it into AD?
Answer Question
| September 8, 2010 1:32 PM
Active Directory, Active Directory migration, CSV, CSV file format, Excel functions
I am looking for a source of macro commands for excel 2007.
I am looking for a source of macro commands for excel 2007. Having used Lotus I am used to writing my macro’s using a command type format. Upgrade to Windows office has put Excel 2007 on my system and I am not able to understand the help function. Books I have obtained have been no [...]
Answer Question
| July 9, 2010 4:44 PM
Excel 2007 macros, Excel functions, Lotus Notes to Excel, Office 2007 deployment
I am looking for a source of macro commands for excel 2007. Having used Lotus I am used to writing my macro’s using a command type format. Upgrade to Windows office has put Excel 2007 on my system and I am not able to understand the help function. Books I have obtained have been no [...]
Answer Question
| July 9, 2010 4:44 PM
Excel 2007 macros, Excel functions, Lotus Notes to Excel, Office 2007 deployment
I wish to have my macro copy a cell from a tab, then go to another tab and search specifically for the value of the initial cell.
Hi. I wish to have my macro copy a cell from a tab, then go to another tab and search specifically for the value of the initial cell. i.e. the VB code should allow the “Cells.Find(What:=) to be VARIABLE based on what is pasted. Any suggestions?
Answer Question
| June 30, 2010 1:51 PM
Excel 2007, Excel 2007 macros, Excel functions, Excel VB code
Hi. I wish to have my macro copy a cell from a tab, then go to another tab and search specifically for the value of the initial cell. i.e. the VB code should allow the “Cells.Find(What:=) to be VARIABLE based on what is pasted. Any suggestions?
Answer Question
| June 30, 2010 1:51 PM
Excel 2007, Excel 2007 macros, Excel functions, Excel VB code
Exporting data from SSIS to Excel
I am trying to export data into Excel from SSIS. For the purpose of this question, the table is called “products” and has two columns. I would like to extract each row of data into a separate Excel file and save it with the product name so I can email it accordingly. How do I [...]
Answer Question
| April 8, 2010 3:18 PM
Excel functions, Microsoft Excel, SSIS
I am trying to export data into Excel from SSIS. For the purpose of this question, the table is called “products” and has two columns. I would like to extract each row of data into a separate Excel file and save it with the product name so I can email it accordingly. How do I [...]
Answer Question
| April 8, 2010 3:18 PM
Excel functions, Microsoft Excel, SSIS
The “TRUNC” Function in Excel
I used the “trunc” function this way “=TRUNC((H41-(I41*25))/10,9)”, where H41is “=(A41-INT(A41))*100″ and I41 is “=TRUNC(H41/25)”. A41 is 346.95. With the Excel 2003 version on my computer, the result is 1.999999999; when, in fact, the result should be 2. What am I doing wrong? Or is there a fault with Excel?
Answer Question
| April 5, 2010 2:30 AM
Excel 2003, Excel functions, Microsoft Excel
I used the “trunc” function this way “=TRUNC((H41-(I41*25))/10,9)”, where H41is “=(A41-INT(A41))*100″ and I41 is “=TRUNC(H41/25)”. A41 is 346.95. With the Excel 2003 version on my computer, the result is 1.999999999; when, in fact, the result should be 2. What am I doing wrong? Or is there a fault with Excel?
Answer Question
| April 5, 2010 2:30 AM
Excel 2003, Excel functions, Microsoft Excel
Extracting max value from 3 columns of data in exel
My warehouse system contains length, width, and height calculations but the longest side isn’t always in the correct column (length). Does anyone know how to extract the max, median, and miminum measurement across 3 columns of data?
Answer Question
| May 11, 2009 3:27 PM
Excel functions, Microsoft Excel
My warehouse system contains length, width, and height calculations but the longest side isn’t always in the correct column (length). Does anyone know how to extract the max, median, and miminum measurement across 3 columns of data?
Answer Question
| May 11, 2009 3:27 PM
Excel functions, Microsoft Excel
Excel custom format, weekday & date line break query….
I created a spreadsheet which is to act as a rota, with the day and date displayed to the left. I entered the date then went to the custom format tab and entered dddd dd/mm/yyyy so it would display the day and date. So it can be printed with all the relevant data it is [...]
Answer Question
| April 16, 2009 4:34 PM
Excel 2003, Excel formulas, Excel functions, Microsoft Excel
I created a spreadsheet which is to act as a rota, with the day and date displayed to the left. I entered the date then went to the custom format tab and entered dddd dd/mm/yyyy so it would display the day and date. So it can be printed with all the relevant data it is [...]
Answer Question
| April 16, 2009 4:34 PM
Excel 2003, Excel formulas, Excel functions, Microsoft Excel
Problems using VLOOKUP
I have an excel 2003 spreadsheet that contains a Volunteer Worksheet for the purpose of driving clients to doctors offices, and another Transportaion Worksheet that enters the dates and medical facilities to where clients will to be driven. I am utilizing a form, with a drop down list, to find a volunteer and another dropdown [...]
Answer Question
| April 2, 2009 2:56 PM
Excel 2003, Excel functions, Microsoft Excel, VLOOKUP, VLOOKUP function
I have an excel 2003 spreadsheet that contains a Volunteer Worksheet for the purpose of driving clients to doctors offices, and another Transportaion Worksheet that enters the dates and medical facilities to where clients will to be driven. I am utilizing a form, with a drop down list, to find a volunteer and another dropdown [...]
Answer Question
| April 2, 2009 2:56 PM
Excel 2003, Excel functions, Microsoft Excel, VLOOKUP, VLOOKUP function
