The discussions
Sum certain cells in a column if corresponding cells of another
Hello, I want to sum certain cells in a column if corresponding cells in another column contain a certain letter. I have amounts in cells G2:G1...
Conditional equation
Hello, I am desperately trying to write a formula for the following: If C23 is less than 2 but greater than zero, then value of E14, and if not,...
Formula to measure percent of checklist complete
Hello, I am trying to build a checklist where if you have completed the task on the list, you put an X in the cell below that task. As tasks...
If, then formula
SolvedHello, I am creating a spreadsheet for the company airplane. Part of it is to calculate how many of the miles flown were "occupied" (had passengers...
Counting between two given dates
Hello, I need help. I need to count on Excel 2007 between two dates including the start date and end date. But the DatedIF fdoes not work. and...
Using character map in windows 7
Hello, i am using Open Office Writer and i have two questions : First : i want to write arabic numbers directly without using menu bar ( in...
Convert date into month name
Solved/ClosedHello, suppose date has mention 1/1/09 and no month name then how to get the month name
Macro to copy data under matching column header
I am trying to write a macro to copy data from multiple spreadsheets and get the data to paste into the proper matching headers. Here is what I have s...
Copy excel 07 sheet to other & keep formulas?
Solved/ClosedHello, Is it possible to copy an Excel 07 spreadsheet to another window spreadsheet (not another tab but completely different spreadsheet) and keep t...
Excel - active x combobox, selecting sheets
SolvedHi, Am a newbie in trying to automate Excel. I have a workbook with 50 worksheets and a menu sheet. On the menu sheet I created a Actixe X ...
Add-ins not show on excel 2010
Hello, Please , somebody can help me with this wrong I follow all the step for add an add-ins on excel 2010 , But this not appear What i...
How to recover excel password?
ClosedHello, I can't able to open my excel file, i have lost my excel file password please suggest me how to open my excel file and how to recover excel f...
Calculating sum of the amounts of each airports automatically
Hello, I have TWO tables such as below,according to the First Table :the first column (Airport name) the second column is ( the amounts in USD) ...
Creating macro to copy data from one wb & save to new wb
Hello, I am very new to creating Macro's and need some assistance. I have a large report with data for several different campuses. I'd like to cre...
Outgoing mail server smtp
Hello, I am in Shenzhen for business and am getting mail , but I cannot send any from my outlook 2007 , and nobody from the many people we asked kn...
Help needed with excel macro
Hello, I have the following sheet: A B C D 1 XXX Monday 5-Jan 5 2 YYY Tuesday 18-Feb 0 3 ZZZ Wednesday 23-Mar 3 4 AAA Thursday 12-Dec 4 ...
Help on merging multiple excel files data
Hello, I am trying to merge multiple excel files placed in a folder. all of them have same headers and similar pattern of data. the purpose of th...
Many columns return into fewer columns.
SolvedHello, I have a spreadsheet that was exported from Survey Monkey. So the format cannot be changed. There can be data in any of 100 columns. Howeve...
Formula to check for text in column
Hello, I am trying to write a formula that searches an entire column for specific text, if it finds it, then add 1. There are three different text v...
Copy many columns and past it in one single column
Hello, I am trying to copy many columns C,D, and G and paste them into on column B in the first blank cell in the same sheet and I will need to do the...
Convertion of numeric to text
Hello, I have used your program for converting numeric to text in excel but there is problem regarding when we are entering greater than 100000 (o...
Search for a text in a column when found copy cell above it
Hello, Boy Results Ttstm063 Mark Earned Points Earned Boy Results Ttstm063 Mark Earned Points Earned Boy Results Boy Results Ttstm063 ...
If and logic
Hello, I am trying to write an Excel formula where i have a condition statement that varies result. For example if my target figure is > 30 but le...
Copy from one excel sheet to another
Hello, I am trying to figure out if it is possible to copy from one sheet to another. Not the whole sheet, but rather I would like to put cells f...
How to send emails
SolvedHello, Please tell me how to get the blank form up to type & send an email on OE Configuration: iPhone / Safari 4.0 -- Dick McD...
Short cut to merge cells
Solved/ClosedHello, If there a short cut on the key board to merge cells in excel?
Macro to connect to paste all clipboard excel 2007
hello, I wish to make a macro that will paste All from the clipboard Excel 2007 ( do the same as the Paste All Clipboard button ) The cell is A1 sh...
How can i lock the column in excel
Hello, If I have a table or Excel sheet and I made a function in a cell A2 and drag this function to be coped in all column A and finally I wan...
Macro to sort clipboard paste all function
WINDOWS 7 EXCEL 2007 Hello, I would like to make a macro that would convert the data below to (See-Below) LIFETIME RECORD STARTS WINS 2NDS 3R...
How to convert a numeric value into eng. word
Solved/ClosedHello, How to convert a numeric value into English words in Excel plz show that formula
Find and replace underlined words for a blank.
Hello, This is my very first forum joined. I am on a quest to find the if there is a way to search and replace underlined words and replace them w...
Updating excel that has macros
Hello, How can you easily update an Excel workbook that already is using Macros? I need to insert two columns but once I do, I receive errors. T...
Vlookup ?
Hello, I have list of 1000 company names in col A and in col B 20,000 company names. I would like to know if the company in A appears anywhere in ...
Convert numbers to text format:
Hello, i got a problem in my data. there are many soluations already available for converting text format to number. But how can number format ca...
Formating date
SolvedHello, I have date in a cell now i want to see the next cell red color if the next cell is not filled up by the next 10 days from 1st cells date. ...
Help with comparing/deleting columns
Hello, I will be eternally grateful if anyone can help me with the following scenario. I have 4 columns Vendor_Name Vender_Code In...
Formulas
Hello, I ve forgotten some formulas used in excel. Please someone should with this formula used to set ranks eg, first, second, etc. Configur...
Cpoying data from one sheet to another
Hello, i have a excel file. in sheet on i have some data like sr no........name...........father's name.........roll no........ 1..............raj...
How to recover deleted .ost and .pst files
Solved/ClosedHello friends, Outlook.pst file deleted. Now I am unable to configure outlook now.... Pls suggest...how to do now...? How to recover dele...
Product key for ms publisher just downloaded
Solved/ClosedHello, Configuration: Windows XP / Chrome 23.0.1271.95 how do I get the product key after down loading MS Publisher from your web site(X16-32...
Match barcode between 2 sheets
Solved/ClosedHello, I have two diffrent sheets. One sheets has tens thausand lines with barcode value,description and quantity of product. another one has 2...
Excel multiple function
Hello, I need to put multiple functions into a one cell result in Excel. The result of one function (result A), squared (result B) and that numb...
I want to extract specific data from microsoft excell cell
Hello, i want to extract the following details into another collumn (bold ) from data in collumn B1 into C1. The information i want begins with 3 di...
Office publisher
Hello, I have downloaded Office Publisher Free. while installing, it requires a CD Key. Where to get it from. Thanks
Deleting a progress bar from powerpoint presentation
Solved/ClosedHello, I used the following method to add a progress bar to my PowerPoint presentation - now I don't like it. https://ccm.net/faq/937-insert-pr...
How can i eliminate #value in calculated cells
SolvedHello, I am building an Excel calculation sheet for cookeries for christmas. In cell H$7 I have the input for how many times I would like to ...
Excel/toshiba problem
Hello, having a problem in Excel. my arrow keys seem to work spontaneously and are continuously scrolling me across the screen - makes it difficul...
How to find missing numbers in a seperate column from 2 columns
Hello, I have data in 2 columns (given below) and want to compare both the columns and want to get the missing numbers in seperate column. e.g ...
Convert number into words in excel 2007
Solved/ClosedHello, i'm trying to convert number into words in excel 2007. i've written coding in VB module. But I don't know how to get it in my function list...