Excel Forum
-
Summing up data from groups & pasting it another column Solved/Closed
Hello there, I need to write a macro for the following example: A 2 A 3 A 3 B 4 B 1 B 4 C 7 D 3 D 8 Etc. Basicallly i ne...
-
Special sum of a column Solved/Closed
Hello, In have some columns with plenty of data. And I need to make a column which will have ... D2=C2 D3=C2+C3 D4=C2+C3+C4 ....................
-
number to word Closed
Hello, i want to covert number in to word like 1000(one thousands) 100 (one hundred) Plz help me to convert number to word in this format Conf...
-
Comparing data in multiple excel worksheets Closed
Hello, For work, I was given an excel document with a different worksheet for each month in 2012. Clients can come to our food pantry one time in ...
-
Calculation of Time Closed
Hello friends Pls help me to calculate time in excel. Time value is A1 is 15:25. I have to subtract 11:30 hrs from A1 and doing calculation lik...
-
excel question nt answered by kioskea Closed
Hello, you have no answer of my question . Configuration: Windows 7 / Internet Explorer 9.0
-
summary of two or more excel sheets Closed
Hello, i want to do summary of two or more worksheets in a single worksheet to review the data and anlysis. is there any method to do this. pl...
-
Formula for Identifying letter with sum value Closed
Hello, I am new to Excel and know very basic formulas. I have made a spreadsheet and have everything pretty much ok except for one part I need ...
-
macro code for sum of 3 rows Closed
Hello, I have a problem. I have a data in which there is only 1 column but 1000 rows. I need a macro to get sum of 3 rows. can anyone help me...
-
Office excel & outlook Closed
Hello jim, "I have a Excel Sheet in which details of member are recorded with there Date of Birth and e-mail id. and I want to wish them on there ...
-
Problems with IF-function... Closed
Hello, I'm using Excel 2003 (yes, still) and I'm having trouble with the IF function. I have a 13-digit number in E2, and in F2 I want the funct...
-
Column addition automatically Closed
Hello, I get raw data base from client, My first work is to insert two new columns in Column 6 & 7.....Is it possible to do it through macro ?...
-
Excel Formatting Closed
Hello, I am having trouble with a formula in Excel. I have 600 rows of financial data. Column A has numbers 1 thru 6, which correspond with differe...
-
Need help with Percentage Please Solved/Closed
Hello, I am new to excel and I am not very good at it so any help would be greatly appreciated. I know anyone out there is helping for no reason o...
-
how to get the data while entering in the other cell Closed
Hello, Thanks for your reply. But what i need is if i enter a student ID in a cell in sheet 1 it must open the student details of concerned id in...
-
how to find the data by entering the data in one cell Closed
Hello, we are dealing with projects of different colleges. there is a data of more than 1000 students. each time i have to click on the respective...
-
Copy rows to different spreadsheets based on 1 column Closed
Hello, I have a spreadsheet where I track open orders for my company. We track this by multiple metrics and values. I currently manually copy and ...
-
Populate data in Excel according with n Solved/Closed
Hello all, My intention is populate an Excel sheet with a variable number of rows according with a number inserted on a fixed column. co...
-
Conditional formatting using dates in different cells Solved/Closed
Hello, I need help with a problem that is driving me insane. I have column A, B, and C A is date started B is date finished C is days it to...
-
Percentage formula? Closed
Hello, I have a column in a Micosoft Excel spreadsheet that contains Yes & No answers. Can anyone please tell me how do I find out how many Ye...
-
Compare and count two columns Closed
Hello, I am struggling with a fairly basic excely problem. I have 2 colums Feb 2012 and Feb 2013 each have a number of different crime types...
-
comparing data in two columns and setting a value Closed
Hello, I'm comparing data in a very big database. and want to assign a value to matching data. For example A B ...
-
Excel Search words from a cell and assign txt in another cell Closed
Hello, I am having data like whi below: A B 1. customer1 TV Fridge ...
-
Macro - Copy speciffic columns when value is X Closed
Hello everyone, I've been having a problem for a while and seem to be unable to solve it. I am now trying to get it done with Macro's but run...
-
Percentage formula Closed
Hello, I have a column in a Micosoft Excel spreadsheet that contains Yes & No answers. How do I find out how many Yes answers I have compared a...
-
EXCEL MACRO Copy/Paste and Insert Rows Closed
Hello, I am trying to write a macro that takes data from a filter and copy and pastes it into a template to create a standardized set of reports. ...
-
date formant in excel sheet Closed
Hello, how to solve date formant in excel sheet Configuration: Windows 7 / Firefox 17.0
-
pulling data from multiple cell's in a series of spreadsheets Closed
Hello, I have already done some searches for help on this but I don't think I am coming up with the right way to say it to search for it probably. ...
-
excel macro Closed
Hello, how can i create the alert excel macro when the cell is changed Configuration: Windows 7 / Firefox 18.0
-
snding sms from excel sheet Solved/Closed
Hello, i need to send text message from excel sheet to mobile number. is there any method to send sms. please help me to give method. thanks ...
-
Transferring data from one excel to another Closed
Hello, I am trying to transfer an array of data from several spreadsheets used by individuals to a "master" spreadsheet that will be stored on a shar...
-
Formula problem Closed
Hello, I am trying to use a tracking number ex: WP 2013-0001 on excel. I want it to generate in the row automatically with WP 2013-0002 and so on....
-
Dropdown lists in excel 2007 Solved/Closed
Hello, I want to create dropdown lists in excel, it should work as follow:In cell2,1 must be a drop down list with 4 names (e.g.Mill,Comp,Loads,Blend...
-
need help from excel formula Closed
Hello, I want a formula in excel : in a worksheet ina single cell an amount will display which will be written in another worksheet . Example...
-
I need to replace jpg description with a number Closed
Hello, I have thousands of jpgs that are named by a product description, like Beltwayjacketblack.jpg, and I need to replace jpg description with a p...
-
Conditional formatting Closed
Hello, If cell P5 is greater than Q5, I need cell R5 to equal Q5. If P5 is less than Q5, I need cell R5 to equal P5. Any help would be appreci...
-
Selection of Data from multiple sheet Closed
Hello, I am facing a problem, regarding selection of specific rows from multiple sheet in a single workbook. Details: I have a workbook with...
-
input search and jump to cell Closed
Hello, i am trying to create a search field cell where i input my data, that i want to search for, as soon as i hit enter it finds and displays m...
-
Using Vlookup to return insted of 00/01/1900 Solved/Closed
Hello, I am using a Vlookup to return values within a sheet using cell A2 as my reference some of the data that I am returning via the lookup are ...
-
Excel 2010 - Macro for filling in Top half of several Excel form Closed
Hello, I have about 14 Excel 2010 forms that lines 2-6 contain the identical information, after filing in the information in on the first form, I ...
-
Formula for Between to Dates Solved/Closed
Hello, Hi, I am looking for a date formula that will tell me if a date in a cell is between to dates In column "A" I have a list of dates and in c...
-
conditional transfer of rows to another sheet Closed
Hello, I am working on a production worksheet. Sheet1 is called "Lead Input" and contains columns of names, addresses, prices, etc. There are two ...
-
Balancing totals from two workbooks Closed
Hello, I have tried some pivots, some access but still no solution. I have data coming from two different sources. One has a breakdown for some...
-
Hide the formula Closed
Hello, I am creating an excel sheet where I need to have a cell show 55% of a number that will change weekly. How do I set it up where the original...
-
Conditional Formatting Closed
Hello, I'm using Excel 2010 (not sure whether or not that matters) I'm not very familiar with conditional formatting, so I need help with somethi...
-
Looking For a Value in a Cell Closed
Hello, I am using the following formula below =IF(OR(A1=" ",B1=" ",C1=" ",D1=" ")" ",G1) What I am trying to do is if all the cells are blank ...
-
one cell will turn green when the two other cells match Solved/Closed
Hello, I am keeping a register of staff in our department. What I want to happen is for the cell (where the name is) to turn green when the date ...
-
=month(d2) Solved/Closed
Hello, Empty cell in Excel file has changed in the month, while 0 is 1 reply should have come to help please Configuration: Windows XP / Chrome...
-
Adding specific days to date Closed
Hello, Configuration: Windows 7 / Internet Explorer 9.0 how to add 21 days to date 25.02.2012 in Cell A1 in excel 2007
-
Macro to email picking up email address in one cell using lookup Solved/Closed
Hi can anyone help me I am using the VBA below to email a results sheet to various people,the code that I have will only allow me to email to one pers...