Excel Forum
-
Excel IF formula [Closed]
Haven't used Excel in quite some time so this is pretty beginner. I just want to make a formula that turns a cell a different color based on the date...
-
Create a macro [Closed]
Hello, Please help. I am hoping that someone will be kind enough to adapt this macro that I can run each month that will return the following infor...
-
Need help to create an excel macro (Combine columns) [Solved/Closed]
Hello, Inputs Col A and Col B ( all data ranges are variable), need out put in C Col. (MACRO), I not good at vba/e , kindly help. Col A ...
-
Matching First and second names with ID numbers [Closed]
Hi I am new but really need help. I need to match a list of names with there ID number. The list of names is small only about 200 but the ID is is...
-
add two type mix font in one cell in excel 2003 [Solved/Closed]
hallo i have a excel 2003 userform with textbox . I have problem in my data base . I have 2 type font in my data like DevLys 010 and arial. I want to...
-
Finding missing data in column [Closed]
Hello, I have two columns of data column A and column B. There is data in Column B that does not exist in Column A. I am trying to use a formula...
-
Recurring date formula [Solved/Closed]
Hi All I have the following formula in my worksheet =IF($AA$2=2,B8+28,IF($AA$2=1,B8+7,IF($AA$2=3,EDATE(B8,1),IF($AA$2=7,EDATE(B8,12),IF($AA$2=4,...
-
cant format date in excell [Solved/Closed]
Hi, When I enter the dates as number with out forward slashes, and format them by right clicking on format cells and choosing date the date appear...
-
Lookup same Entry A1 in 2 worksheet & return B1 from 2nd w/sheet [Solved/Closed]
Hi, I have 2 worksheets. "Master" = Sheet 1 "Status" = Sheet 2 In "Master" Worksheet there are 3 columns, A1-User ID, B1-Username, C1-Status...
-
Conditional format to shade rows if value or date is found? [Closed]
Hello, I am new to conditional formatting and trying to create a few function that will work in Excel 2010. First I am trying to grey out (or sh...
-
indirect sum with reference to range on other sheet [Closed]
Hello, I have a workbook with 2 sheets Weekoverzicht and Grafieken The sheet weekoverzicht is populated by a macro. The macro starts with d...
-
filling in data [Closed]
hi, i have the following query for my work. What i have to do everyday is to manually amend the bolded data and it is tedious. is there any way i ...
-
Trouble with IF/OR function in Excel [Closed]
Hello all! I'm hoping you can help me with a problem I'm having. For reference, I have Excel 2008. My goal is to write an IF/OR function. The funct...
-
Macro to create new excel when last row is filled [Closed]
Hi, The data will be automatically filled in my excel sheet and it will be more than 1500 rows. now i want a macro that automatically create a new ...
-
Copy and paste range of cells in Xcel [Closed]
I would like to copy an paste a range of cells (A1 - A15 )in Xcel to the same row and be given the option to specify the amount of iterations of this ...
-
Macros to Insert rows defined in column "X" [Closed]
Hi, I m new to macros, need your help to create macro per my below requirement... Eg.. Value updated in column "A" is 10 so it should add 10 new...
-
Macro on a pivot [Closed]
Hi I have been trying to find a macro that copies a cell and pastes into a number of cells beneath it until it reaches another cell that has data, ...
-
macro to insert picture in text box [Closed]
sir i have names in A1:A5 of customers on sheet1. I created folders named CUSTOMERS ID and SIGNATURES in D:. I scanned images of customers Ids and Sig...
-
Can This be done? [Closed]
Hello, I have a spreadsheet that I created with the help of ac3 mark. Thank you Again. It works well and now i would like to see if i can add mor...
-
Macro Range [Solved/Closed]
Hello, I am somewhat inexperienced in the world of macros in excel. I have a looping macro that runs from the bottom and i want it to stop at ...
-
How to tranfer information [Solved/Closed]
I am wanting to set up a sheet that inputs information on another sheet in excel. The problem is, I want it to list the information from one section o...
-
I am just learning the basics [Solved/Closed]
Hello All, I am new to this community. I have just started learning Excel and am having a problem with a formula. the community here from what I have...
-
formula help [Closed]
Hi, I'm looking for a formula for the following scenario: Worksheet 1 Cell A 129622 Worksheet 2 Cell A Cell B Cell C 129622 1,000 35 ...
-
adding a formula [Closed]
Hello, how do i may be able to get auto deduct formula from a sum method of multi cells ? Thanks
-
Conditional format based on two criteria [Closed]
Hello, Can someone help me please with a conditional format that would highlight an entire Row in 2010 if Column B on my spreadsheet has any one o...
-
Conditional formatting using a formula [Closed]
I would greatly appreciate any and all help, please and thank you so much in advance! I am trying to create a conditonal format on a row of cells b...
-
convert numbers to words in excel [Closed]
Hello, please give me the formula for converting numbers into words not not into currency and it should be like when I type a number such as 400 i...
-
Create a macro [Solved/Closed]
Hello, Please help me. I am new at macros, and I need to create a macro that will automatically total a column as below: # Name ...
-
Need help with an IF function [Solved/Closed]
So, I am trying to get this formula to work. The situation is that one of our items have changed names. In the spreadsheet, I am trying to get a f...
-
convert number to word in excel [Closed]
Hello, i want a number to be converted to word in excel such that if i enter a number as 600 it should show as six zero zero please help me sir ...
-
Excel date problem [Solved/Closed]
Hi, How can I change the date format from a format such as 22042013 - (this is not a text format). One formula I have been given is: =IF(LEN...
-
about the VBA [Closed]
Hello, Im Kumar and would like to knoe how to setup the VBA in a snapshots. it would be more thankfull if u provide me the snapshots
-
create a macro [Closed]
Hello, I am new at macros, and I need to create a macro that will automatically total a column as below: # Name Amount Total 0...
-
Any part of string in cell matches part of string in another [Solved/Closed]
First post after hours of fruitless googling :-) Working in Excel 2010.. I have merged two data sets and where there are instances of exact dupl...
-
excel email notification [Closed]
i have a excel sheet in my server which can be controlled by all my engineers, i should get a email notification if any of my engineers access to it a...
-
IF SUM commands [Closed]
Hi! I have a column with number of mice drinking water.. 5 3 8 7 15 10 =IF(A3>10, 300,IF(A3>=7, 250, IF(A3
-
Delete Rows Based On Phrase in Column [Closed]
I am trying to make a macro that deletes a row in a column if it detects a set of specific words or phrases. "Friendly's" "Ruth's Chris Steak Ho...
-
Help - Macro to delete rows with specific text or phrase. [Closed]
I am trying to make a macro that deletes a row in a column if it detects a set of specific words or phrases. "Friendly's" "Ruth's Chris Steak Hou...
-
Creating new sheet and transferring data to new sheet [Closed]
With due respect I would like to have some Guidance for creating a excel sheet. My sheet is Date name in out time. This sheet contains 746 rec...
-
Inserting multiple rows with copy and paste the existing data [Closed]
Hi The below code works fine with inserting new rows but I need an extension of the code to incorporate copy and paste function on the existing ro...
-
Help Please with calculating large data in Pivot Table [Closed]
Dear Sirs, Can some one please help me with creating a better Pivot Table in Excel 2010. I work for an automotive company and so have to track all...
-
Conditional formatting can't caputure text...NEED VB CODE PLEASE [Solved/Closed]
Hello, I understand i can't use c formatting to insert text and therefore am looking for a piece of code that will perform the following. Consi...
-
Conditional Formatting Based On Changing Dates [Solved/Closed]
I am trying to keep on top of dates that are changed weekly based on last weeks dates, but i need to highlight the changed cells only. Example: ...
-
Conditional Formatting based on two conditions [Closed]
I need to know how to set up a conditional Format for a worksheet that changes every month. I need to have the format highlight an entire row if the ...
-
please answer me. [Closed]
ram-5,raja-2,rani-6,ram-2( i want to know the excel formula for count th total no. of ram )
-
Formula help [Closed]
I have a table of window blind size prices. The price changes due to the width and drop of the blind. The headings along the top of 450mm, 600mm, 750m...
-
find and compare calues in two columns [Solved/Closed]
Hi i need to look for values (strings) in column A and see if exist in column B. if exist return the line number. (tried vlookup but i get only ...
-
Help with cell programming! [Solved/Closed]
Hi everyone. this is my first time here, and in desperate need of help from some Excel Genie to make my wish come true! Ok, here is my "urgent" pro...
-
Conditional Formatting in Excel2010 [Solved/Closed]
I wish to have the following CF in more than three colours. I have placed the following in Data List L1,L2,L3,L4,L5,L6,M7,M8,M9,M10,M11,H12,H1...
-
Help needed in using marcos [Solved/Closed]
Hi, I need to write a marco that is able to compare the specific column in 2 different worksheets within the same workbook. (i.e Names of staffs) ...
Subscribe To Our Newsletter!
DON'T MISS
- How to Recover Your Yahoo Account
- How to Get More Followers on Instagram
- How to Get Free Diamonds in Free Fire
- How to Disabled Write Protection on a USB
- Facebook Code Not Received
- How to Create a Gmail Account
- How to Fix a Blurry Snapchat Video
- Computer Boots to Black Screen
- How to Install a VPN
- How to Recover a Disabled Facebook Account
- How to Upload High Quality Photos to Instagram