Excel Forum
-
Covnvert numbers to single words [Solved/Closed]
Hello, In excel 2010 i would like to convert numers to words i.e. 123.00 (one two three point zero zero) or 1006235.23 (one zero zero six two thre...
-
Tranferring of Excel [Closed]
Hello, I have two excelwork sheets For example A and B. Sheet1 of Workbook A consists of data and sheet1 of workbook B is empty. I want to transfe...
-
Leaving a Cell Blank if one value of the formula is blank [Closed]
Hello, I was making a template to be distributed to multiple receivers. Since the template is blank and must automatically count the number of day...
-
using multiple if functions with data validation [Closed]
Hello, Im trying to create a pull down menu with data validation, however for example if M4 = VT-901 then I want to be able to select a size 1080,...
-
Compare and copy data from one column to another [Solved/Closed]
Hello, I'm trying to compare column A in Sheet 1 with column A in Sheet 2, then copy corresponding values in column N from sheet 1 to column N in ...
-
Excel Mini Challenge [Closed]
Hi, I need to compare 2 versions of the same data which reside on 2 different worksheets (within the same workbook). On the first sheet (the...
-
Forluai [Closed]
Hello, I am using Microsoft office as well excel, I am not expert in excel. Could you give a favour for its formulas and their applying tricks and...
-
MS OFFICE EXCEL [Closed]
Hello, HOW DO I FIX A FORMULA TO CHECK THE FOLLOWING: IF YEAR "2012" AND MONTH "FEBRUARY" THEN NO. OF DAYS IS 29 OR ELSE 28. FOR JANUARY, ...
-
excel formulaes [Solved/Closed]
Hello, If there are two conditions, how to use the IF formulae. Regards
-
Help on generating a number series using a macro [Solved/Closed]
Hello, I would appreciate your help with a macro I am trying to create in Excel 2010 my Data is as below Column1 Column2 Column3 (Name) (start nu...
-
Hide rows meeting multiple criteria and search for unique values [Closed]
Hello, While hours reading posts and forums have increased my knowledge of VBA in which I can create parts of the following request I am still unab...
-
Conditional Formating a word within a sentence - Resent [Closed]
Greetings, I am trying to highlight a word in red or blue that is located with a sentence in excel. The word "Reversal" exist in several sentenc...
-
dynamic range and named ranges [Solved/Closed]
Hi, I have a list of students in Sheet 1,2,3 where being updated regularly. They are named ranges "Boys" & "Girls" in Column A & B respectively. In...
-
Excel 2003 [Closed]
Hello, Can you help me, I am trying to write a conditonal formula in Excel 2003 that goes something like: If current date is 6mths from date o...
-
complete payroll computation [Closed]
Hello, i would like to learn how to do payroll transactions. can you help me? thanks Configuration: Windows 7 / Chrome 23.0.1271.64
-
compare 2 cells in different worksheet and place the value [Closed]
Hello, I am not expert in excel, and i need help to use a formula to compare 2 cells in other worksheet and fill the value in a blank cell if it is t...
-
Delete certain data from Excel [Closed]
Hello, Im playing with big numbers of data in Excel. I want to do data cleansing process. How I want to delete certain rows that unnecessary anymore...
-
Excel Dates [Closed]
Hello, I have two excel sheets. In sheet one i have certain dates associated with certain IDs. In sheet two i have certain dates associa...
-
Calculate Sales [Closed]
Hello, I want to keep track of my sales.I have four columns.Below is excel data. Show only one day at a time. Date X Y Z 08-11-1...
-
Macro - Add row, auto fill text and formulas with relative OFFSS [Closed]
Hello, I have very big problem and I can't find answer for it. Maybe You can halp me. 1. In Sheet "Intro" I have row (5), in wich are formulas:...
-
compare dates in excel [Closed]
Hello, Hello, I have two excel sheets. In sheet one i have certain dates associated with certain IDs. In sheet two i have certain da...
-
If row in column contain word, insert text next column [Closed]
Hello, I have an excel files, and in column B I have a file path, but if it contains a specific word like "proprietary" I need to insert into the ...
-
multiple data in one column [Closed]
Hello, How do I plot multiple data in one column? Example: I submitted 10 for today. So my column chart will show a column with a value of 10...
-
multiple data in one stacked column [Solved/Closed]
Hello, i am trying to plot a column chart and I want multiple data to appear in one column. example: I am plotting all the submitted inspections...
-
Matching columns in one spreadsheet [Closed]
Hello, I have a spreadsheet that has last names in column A and first names in column B. Somehow they no longer match. For instance -Mary Smith...
-
formula 3 books open in excel [Closed]
I have 3 books open in excel (Book 1) I would like to make my template. (Book 2) is a spreadsheet of stores. (Book 3) is a spreadsheet of opera...
-
array example to remove duplicates entry [Closed]
Hi there, I have three column for lookup and i used combination of all there as a primary key to look into master sheet. want to remove the dupl...
-
macro to create new workbook for each column [Closed]
Hi All, I would like to ask for your very kind help to the below query. I have a big excel files say containing 100 + 1 extra columns. I wan...
-
Creating a Macro [Closed]
Hello, I am trying to remember how to create a macro that will allow me to compare values in column A from sheet 1 to column A on sheet2 and if th...
-
Matching similar data in 2 columns [Closed]
Can any super Excel guru help me please? I am trying to find out the same item from 2 different database: I have 2 columns of product code, for exa...
-
VBA for deleting data in row but not formulas [Solved/Closed]
Hello, I am working on a spreadsheet where I have to copy data over to a new sheet, once the data is copied I want to delete the data in the row f...
-
drag the mouse [Closed]
Hello, i could not drag the mouse. how to do drag the mouse to down, what are the settings ? Configuration: Windows XP / Firefox 16.0
-
Automation of running excel macros [Solved/Closed]
Hello, I have a macro in excel which needs to be run twice a day and I dont even want to open the excel sheet. How can I make this process automati...
-
Help in Writing VBA Macro excel [Closed]
Hello, I wish to write a macro for following: 1. Delete entire rows if column L or column M contain DATE. 2. Move deleted entire rows to other...
-
Comparing two cell in different spreadsheets [Solved/Closed]
Hello, I'm currently struggling to do the following: Spreadsheet A Sheet1 Name Expenses Date ...
-
Insert X Number of Rows Below Based on Value of X [Closed]
Hello, I have in Cell (B,3) a count indicating number of rows to be inserted below without deleting values in subsequent cells, in cell (B,4) anot...
-
search & copy function (macro) [Closed]
Hello, First of all, i will thank all who reads this question. And such a good forum. I have a question regarding a Macro. Basically i have...
-
Comparing Two Lists of ID Numbers in Excel [Solved/Closed]
Hello, thanks in advance for reading this. I have a list of student ID numbers which I would like to use as a student check-in. Column A is the num...
-
loops [Closed]
Hello, I have a spreadsheet that was converted from pdf, but the info is not in rows like a normal database. The headings are repeated throughout...
-
Update cell value by Command button [Closed]
Hello, I would be very grateful if someone can help me in the following issue. I have excel sheet with almost 300 rows. One of the columns I fil...
-
Reminder in MS Excel 2003 [Closed]
Hello, I would like to add reminder which displays reminder message once it opens. Onething I dont know the VB or something extra programming soft...
-
excel i want to sum only numeric values except alphabetic values [Solved/Closed]
Hello, in a school resultsheet where each student having numeric values of their marks in 5 subjects.i am using formula =D6+F6+H6+L6+P6 for total ...
-
change cell color based on input in a range of cells [Solved/Closed]
Hello everyone, I have formatted a cell based on a specific text entered in one cell. Example, A1 will turn green if I write "yes" on B2, using cond...
-
Nested if's [Solved/Closed]
Hello, I would appreciate if somebody could help me in solving this problem. I am trying to make exel decide in an scheduled soccer games which team ...
-
Excel date format won't change [Solved/Closed]
If I enter a date into a cell in my Excel spreadsheet using the shortcut (CTRL+;), I can no longer change the formatting (right-click, format cell). T...
-
ActiveChart.SeriesCollection [Closed]
Hi, Guys! Can anyone help me with this code below. I want to make the range of the ActiveChart.SeriesCollection to be from $C$3 to my last cell wit...
-
Pop up reminder [Closed]
Hello, 5 day Pop up reminder for excel in vba that runs in excel 2007 I'm new to this hope you can help Thanks djandpj Configuration: Windo...
-
Macro to merge rows but keep column data [Closed]
Hello, I am new to this and I have seen there a number of questins regarding merging rows in Excel. I hope someone can help with this one: I h...
-
Macro - Predefine column ID [Closed]
Hi There, in order to add more flexiblity, I want to predefine the column criteria/search column ID at frontend ie in excel sheet and use it at ba...
-
excel,problem with if function [Solved/Closed]
Hello, i am working with excell with follwing formula- =IF(H33>=75,"A",IF(H33>=60,"B",IF(H33>=45,"C",IF(H33>=33,"D",IF(H33>=0,"E",IF(H33=AB,"E"...
