Excel Forum
-
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...
-
duplicate data from on tab to a master tab [Closed]
Hello, I need to create a work book wit 5 tabs? The 1st tab will be a Master Page and the 2nd,3rd and 4th will be data inputted by other users,...
-
returning value from column b in column c, in a cell ajacent to [Solved/Closed]
Hello, BHID MN Samp 47.86 Samp 50.24 Samp 41.63 Samp 49.34 Samp 48.19 Samp 53.11 Samp 50.98 Samp 49.07 Samp 48.05 Samp 52.96 Samp 41...
-
How to download? [Closed]
Hello, I want to down load Excel and Microsoft Publisher Configuration: Windows 7 / Internet Explorer 9.0
-
Recovery my work and restart microsoft excel [Solved/Closed]
Hello, everyone i have a problem with my excel while I start this program then open the file in MS Excel. Excel pops a message saying "MS Office ...
-
compare data in seperate columns to find likely matches [Solved/Closed]
Hello, I want to compare data in columns which essentially is the same but worded different. For Example Name of Person County...
-
No tool bars or address bar on my browser [Solved/Closed]
Hello, I don't know what I did, but my address bar is only visable when I drag my mouse up to the top of my screen and my toolbars have disappea...
-
Excel function [Closed]
Hello, please i need your help in the following problem I have one worksheet contains many colums, rows, and calculations as follows: empl...
-
Code for macro that conditionally inserts rows [Solved/Closed]
Hello, I know this has been asked and answered often, in particular here: https://ccm.net/forum/affich-222200-insert-rows-on-change-of-value-in-excel-...
-
HELP!!! CONDITIONAL FORMATING [Closed]
Hello, I have a spreadsheet (d2:d7) with 2012 prices in column D2 and 2013 prices in column D3 for the same product...what i want is if D2 is bigg...
-
Excel if function: less than date [Closed]
Hello, I need a what if formula to satisfy the following: if date in K34 is before 23 Nov 2012, then AB34 = yes and so on.. i.e date in K35> 23 N...
Subscribe To Our Newsletter!
DON'T MISS
- How to Upload High Quality Photos to Instagram
- How to Disabled Write Protection on a USB
- How to Install a VPN
- Facebook Code Not Received
- How to Get More Followers on Instagram
- Computer Boots to Black Screen
- How to Fix a Blurry Snapchat Video
- How to Recover Your Yahoo Account
- How to Recover a Disabled Facebook Account
- How to Create a Gmail Account
- How to Get Free Diamonds in Free Fire