Excel Forum
-
Conditional equation [Closed]
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 [Closed]
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 [Solved/Closed]
Hello, 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 [Closed]
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...
-
convert date into month name [Solved/Closed]
Hello, 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 [Closed]
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/Closed]
Hello, 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 [Solved/Closed]
Hi, 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 ...
-
Comparing two spreadsheet data [Closed]
Hello, If I have an original sheet comprising of 8 columns and a number of other row items with subtotals in between. The next sheet contains t...
-
Add-ins not show on excel 2010 [Closed]
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? [Closed]
Hello, 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 [Closed]
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 [Closed]
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...
-
Help needed with Excel Macro [Closed]
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 [Closed]
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. [Solved/Closed]
Hello, 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 [Closed]
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...
-
MSOffice 2010 [Solved/Closed]
Hello, How can I customize Naira Symbol in MS excel Office2010. Thank you.
-
copy many columns and past it in one single column [Closed]
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 [Closed]
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 [Closed]
Hello, Boy Results Ttstm063 Mark Earned Points Earned Boy Results Ttstm063 Mark Earned Points Earned Boy Results Boy Results Ttstm063 ...
-
Aline data horizontally in excel using vba or vbs [Closed]
Hello, ...
-
If and logic [Closed]
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...
-
All permissions in protected and shared workbook disabled autom [Closed]
hello friends, Version: Excel 2007 OS: Windows 7 Professional Situation: I have a 1000 rows X 50 columns of data. Filters are applied on th...
-
Copy from one excel sheet to another [Closed]
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...
-
Short cut to merge cells [Solved/Closed]
Hello, If there a short cut on the key board to merge cells in excel?
-
Macro to connect to Paste All Clipboard Excel 2007 [Closed]
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 [Closed]
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 [Closed]
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...
-
Updating Excel that has Macros [Closed]
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 ? [Closed]
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: [Closed]
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 [Solved/Closed]
Hello, 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 [Closed]
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 [Closed]
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 [Closed]
Hello, i have a excel file. in sheet on i have some data like sr no........name...........father's name.........roll no........ 1..............raj...
-
Match barcode between 2 sheets [Solved/Closed]
Hello, 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 [Closed]
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 [Closed]
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...
-
How can I eliminate #VALUE in calculated cells [Solved/Closed]
Hello, 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 [Closed]
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 [Closed]
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 currency (Indian) into words [Closed]
Hello, daer Sir, i need to convert currency (Indian) into words while working on my excell work sheet,as in Excell there is no farmula availab...
-
How you can get an atomatic serial number in a particular column [Closed]
Hello, Suppose A1 is serial, B1 persons name, C1 amount due, D1 amount paid, E1 invoice number, F1 is invoice date and so on, that is A2, B2, C2........
-
Excel Macro Sort and Data series [Closed]
I'm looking for a macro that will accomplish 2 things: first I want to sort a range called "data" primary key is "com", secondary key is "cvt", next ...
-
Conditional Formatting Highlight Entire Row Based on Date [Closed]
Hello, I'm trying to highlight an entire row in excel if the date in column B is later than today. Can you help? Please. Configuration: Window...
-
Help with a VBA code [Closed]
Hello, I'm trying to configure the DEL key to clear the contents and Unlocked the cell (if Locked). I create the module: Public Sub MyDelKey() ...
-
Look for values from a different sheet and return it [Closed]
Hello, So I am working with a file that has 2 sheets. Sheet 1 has columns A,B,C,D Sheet 2 has Column. A B C D For both sheets, column A= ...
-
Macro Help [Closed]
Hello, I wrote the below macro but my problem is the number of rows change each month so i would like to have an autofill the formula from column ...
-
copy range depending on a cell values [Closed]
Hello, i am looking for a script that gives me the following : column A to D contains my data that I want to copy to another sheet, E/F contai...
Subscribe To Our Newsletter!
DON'T MISS
- How to Disabled Write Protection on a USB
- How to Get Free Diamonds in Free Fire
- Computer Boots to Black Screen
- How to Recover a Disabled Facebook Account
- How to Upload High Quality Photos to Instagram
- Facebook Code Not Received
- How to Fix a Blurry Snapchat Video
- How to Get More Followers on Instagram
- How to Install a VPN
- How to Recover Your Yahoo Account
- How to Create a Gmail Account