Excel Forum
-
Deleting rows with data from columns matching [Closed]
Hi there. Im trying to look for a Macro that will do the following. I have a large data set with a range of numbers. I would like to search tho...
-
Automatic sorting or rows based on the value [Closed]
Hello, I basically work on excel which has huge data.. I need to search a transactions based on the amount of the transaction. As of now I'm using ...
-
How to change a cel color in excel [Closed]
Hello, Can someone help me, if column A for ex. represents time where the number are between 1 and 15 I would like them to change color after 5 mi...
-
Excel Data help [Closed]
Hello, I need to take multiple email addressess from one cell to thier own cell. How do I do that? (IE: TOADD:; jane@comcast.net; bonnie@yahoo.co...
-
Needing an excel formula that has two if/then [Closed]
Hello, I'm trying to come up with a formula that will pull data from a different tab, with two if/then statements. I need the data to pull if cell...
-
Copy multiple cells to workbooks faster? [Closed]
Hello, I am trying to copy values from different worksheets and workbooks into a new worksheet. I know how to do this but it is very time consumi...
-
Copy values to validated cells [Closed]
Hello, I have validated a cell to contain certain values only, say 1 and 0. But if i copy any value from anywhere and paste in the validated cell...
-
Excel refernce to another worksheet [Closed]
Hello, When I try to reference a cell in another sheet of the same workbook, I get the formula instead of the value. i.e. +"sheet 2"!G65 displays...
-
EXCEL NEED HELP WITH GREATER THAN LESS THAN [Closed]
Hi! Can somebody help with something like that? I have a list of members of my airsoft team. Every member collects points and gains military r...
-
Comparing columns and returning value [Closed]
Hello, I had similer proble which was discussed at https://ccm.net/forum/affich-100231-comparing-columns-and-returning-value but with little...
-
how add the rows with the same value in a col [Closed]
Hi Friends, I'm trying to make a macro to have a summary worksheet. - My purpose is to add the data in the rows which has the same ID number in...
-
EXCEL HELP [Closed]
I am a teacher. I have a list of all the students in the freshman class and I am trying to calculate their GPA. Problem is that each students grade ...
-
Excel help - problem with date format [Closed]
Hello all, Actually I created a spreadsheet a while ago now I need to use that one and my problem is that when I entered data that time I used form...
-
Excel validation with if [Closed]
Hello, i want some help in excel: I have column A - Brands (about 10 different) In Column B - types of products of the brands (200 different) In ci...
-
Excel Equation [Closed]
Hello, Add equations to calculate the total cost of the loan by multiplying the number of payments (minus 1) by the monthly payment and adding th...
-
copy the value of one cell from worksheet to [Closed]
Help please...anyone! I'm looking for the formula in excel that copies the data from from a single cell from sheet 1 into a single cell on sheet 2....
-
MS Excel: Value from a Range [Solved/Closed]
Hello, HDI get a numerical value (in C2) that is assigned to a word within a range(G2:H8)? Thank you in advance!
-
Excel how to change a value automatically [Solved/Closed]
This is my first question on the forum so I would first like to start by saying hello to all members and moderators :) My question today which I'm ho...
-
Opening a new Excel Document using VBA [Closed]
Hello, I'm trying to write a vba macro that will open up a new excel document after I have manipulated my data. I want my end product to be in a n...
-
comparing two excel sheets [Solved/Closed]
Hello, i have two excel sheets, one sheet has 100 email ids, the other have 200 email ids, the scenario is I want to know the common email ids from...
-
Active Cell in Excel Macros [Closed]
Hey, I'm pretty new to using Excel macros. I'm writing a macro that will be activated from many different cells. It needs to reference some static cel...
-
Excel Custom Function [Solved/Closed]
Hello, i have created a custom excel function which works fine. the only problem being, you need to press F2 on the custom formula cell and give en...
-
Query in Excel [Closed]
Hi I have two worksheets Pg 1 and Pg 2 Pg 1 has the following Data for 2nd Oct Company Name Volume Traded A ...
-
connection is ok, can't browse the internet, [Closed]
There was no warning, it just started happening, i did not installed anything. Local area network shows lots of bites sent but few received, when v...
-
pls help - Excel - Highlight cell if no data [Solved/Closed]
Hello, Please could somebody help me with a problem. I have a spreadheet and I would like make some cells in a row go yellow if they have no data in...
-
Need Excel2007 Formula Index, partial match [Closed]
Hello, I have 2 worksheets that looks like this: (Windows XP / Internet Explorer 7.0/ Excel 2007) Sheet1: Site Information ROWS COLUMNS ...
-
Count rows from sheet2 and place on sheet1 [Solved/Closed]
Hello, Windows XP / Internet Explorer 8.0, Excel 2007 I need help with a formula. On Sheet1, I am trying to get the total # of records for ea...
-
Dependent cells with data validation [Closed]
Hello, I have let's say cell c18 include a validation list with choices Y,N. Then in Cell c19, I need it to read "0" if cell c18 is "N", but I need ...
-
excel formulas [Closed]
Hello, I have to create a formula that will sum a column if it meets certain criteria. The criteria must sum the list if the date fall within the ...
-
Excel Help... [Closed]
Hello, I am an excel beginner and looking for some help. Here is what I am working with... Unit $35,000 Unit $60,000 Es...
-
compare two columns [Closed]
Hello, i have one column has 100 email ids, the other have 200 email ids, the scenario is i want to know the non-common email ids from both the co...
-
Find name(s) that are in all 4 columns [Closed]
Hello, I have an excel spreadsheet that has four columns and I need to find the names that are in all four columns. The columns are taken from...
-
Excel- Comparing multiple columns [Closed]
Hello, I have 8 columns to be compared with each other. Every column is suppose to be compared with every other column . Objective is to identify...
-
Date change in cell using Excel? [Closed]
Hello, When I'm using Excel, how do you put a date in a cell that will change when you use the file the next day etc.? Configuration: Windows V...
-
Count Conditional Formatted cells [Closed]
Hello, I am trying to count cells that have a conditional format already applied to change their interior color to green (4). I have written a fun...
-
Excel Formula help [Closed]
Hello, I am trying to create a formula in excel so that if I change a number in one cell it subtracts that amount from a different cell for exa...
-
browsing the web with a sansung phone [Solved/Closed]
how to make a phone to browse
-
Excel 2007 if and function [Closed]
Hello, It sound simple but i can't figure it out.. I have 3 cels and i wanne have 1 value example A B C 33572 SNAKE 365 33572 SU...
-
Plz Help- need sheetname for each row importd [Closed]
Hi, 1st of all thanks for the earlier support, it really helped.. Now I am encountered problem in VBA codes, I want to import data rows from mu...
-
using find within macro [Solved/Closed]
Hello, I have a list of first and last names of employees (Sheet1). Some of these employees have adjusted work schedules which are listed in a dif...
-
How can use Opera Mini Browser in Micromax Q [Closed]
Hello, How can use Opera Mini Browser in Micromax Q5fb Handset, who click in icon of Opera than Display Shoown Opera Mini Not Exists Configurat...
-
excel: formula to choose if cell is correct [Closed]
Hello, Anyone know what the formula is to return the value of the cell with no error. e.g. formula returns two results in cells A1 and A2 ...
-
excel macro - to define number of rows [Closed]
Hello, I am trying to copy the number of rows into different column in the same sheet ,i need to count the number of rows because when i recorded ...
-
Changing a cell's color based on other cells' [Closed]
Hello, Please help! I have 5 columns on Excel (A1:E5). I have conditionally formated $A:$E the following conditions: 1. If the numerical value z...
-
Excel..condition based on drop down list [Closed]
Hello, I've created a drop list (using the validation method). in excel 2003. What I wish to do... is create a condition where another cell ...
-
Excel VBA help [Solved/Closed]
Hello, I am needing some help with this vba code. What I am trying to do is first verify if cell A4 is not empty, if it is not empty then I need it t...
-
Vba code to search and delete [Closed]
Hello, I need to know the code to do the following: Search in column D for blank spaces and then delete the whole row. Thanks in advance ...
-
Copy rows from sheet 1 to sheet 2 [Solved/Closed]
I need to have a macro that will copy rows from sheet1 to sheet 2 . The catch is from sheet 1 col A for eg A3 may have the number 10 in it. I need to ...
-
Excel Macro Help to delete first cell [Closed]
Hello, i required a macro coding to delete the first cell in the column. Eg: if i enter any value in cell C11 then automatically the Cell C1 va...
-
To prepare Attendence Report with Excel sheet [Solved/Closed]
Hello, I will describe what I want to do . I have 60 residents working in our department. They attend morning report everyday. So I have prepared ...
Subscribe To Our Newsletter!
DON'T MISS
- How to Get Free Diamonds in Free Fire
- How to Recover Your Yahoo Account
- How to Disabled Write Protection on a USB
- How to Fix a Blurry Snapchat Video
- How to Recover a Disabled Facebook Account
- How to Get More Followers on Instagram
- How to Create a Gmail Account
- How to Upload High Quality Photos to Instagram
- Computer Boots to Black Screen
- Facebook Code Not Received
- How to Install a VPN