Excel Forum
- Solved
-
Insert word in cell based on value in another cell? [Solved/Closed]
CONDITIONAL FORMATTING for cell A2: if value in cell C3 is > than 500, then insert word "alert" in cell A2 what would the formula look...
-
Round UP Formula for TIME [Solved/Closed]
Hi All. I need an excel macro to populate a cell with a time slot based on the previous column which is a datetime value. e.g. if column A is 1...
-
The value of a name [Solved/Closed]
Hello, I've been playing a lot of dark souls 2, and I'm trying to make a spread sheet to have the value for armor (to start). I plan on...
-
Can the formula COUNTA / COUNT exclude 0 values? [Solved/Closed]
If I use COUNT or COUNTA, what can I include in the formula to exclude zero values? Thanks for any tips
-
Transfer data into Invoice [Solved/Closed]
So I've put hours and hours into this with no avail. Here's my situation...I have on "Sheet 1" a list of materials which could potentially be used...
-
Inserting a row when the value of a field changes [Solved/Closed]
I was using this code as a start but can't seem to mak it do exactly what I want. Sub InsertRows() Dim r As Long, mcol As String, i As...
-
Format cell color based on date range [Solved/Closed]
Hi, this is my first post. I'm glad to be a member of this forum. Based on conditional formatting, how can I select a cell and have the...
-
Filtering data from 1 sheet to another [Solved/Closed]
Hello, I have the following problem. Kindly help me with the same: Problem statement: I have data pertaining to projects, milestones and...
-
To show blank record when no data while copying [Solved/Closed]
Hello, I have three sheets sheet1(Active) ,Sheet 2(Inactive) and Sheet3(Total). I have written code which would copy data from Active sheet...
-
add value to one cell if multiple other cells have any value [Solved/Closed]
Hello, I'm trying to create a spreadsheet where: if A1 has any value, 10 is added to the total sum in G1 if B1 has any value, 20 is added...
-
Conditional formatting for cells depending on other cells ranges [Solved/Closed]
First off, I am not even sure if i worded my question correctly, so sorry if i have. What i want to do is... have for cells b4:b7 to have on...
-
How to see if a particular cell in a table has date data or not [Solved/Closed]
Hello, I am preparing a tracking tool to measure the life of an item. The table has Installation No Date 1 ...
-
Highlight the linked cell depends on drop-down list choice [Solved/Closed]
Hello, I have a question. Let say I have a table containing number 1,2,3,4 and 5 in A1:A5. In another worksheet, I have "Student" in A1 and...
-
Conditional Formatting: Merged cell color [Solved/Closed]
Hi, This is probably an easy solution but for the life of me cannot get this to work. I have a situation whereby I have a line of...
-
compare three columns contain same characters [Solved/Closed]
I have three columns of form security access in an application for different classes. The security characters may be in any order. I need to...
-
Excel: Partial Matches in 2 Different Cells [Solved/Closed]
Hello, I've been mulling over this all afternoon and need some help. Here is what my sheet looks like: K L 3 ...
-
determine percentage via formula [Solved/Closed]
Hello, can anyone help me determine a formula that will give me a percentage? If N11 is 2500 and I11 is 84, I need a formula that will help me...
-
two values to find on the same cell [Solved/Closed]
Hi, Can the below be shorten up? It's basically to count if "dr" or "ba" are in cell...
-
Macro to delete row after certain condition found [Solved/Closed]
Hello, I am an Excel newbie; I am trying to write an Excel macro that will search a certain column to find a blank value. It would then delete...
-
if then (text or no text) [Solved/Closed]
Hi, I hope someone can help me with this. I would like to create a formula that says this: if a certain cell contains ANY text, then write...
-
connect two worksheets together [Solved/Closed]
Hello, I am trying to connect two worksheets together. If text found in one cell in sheet1, make the same cell on sheet2 different color....
-
Conditional Formatting: Highlight cells based on two values [Solved/Closed]
Hello, I have a merged cell (C5-N5) that I want to change the fill color, based on the combined input of two cell values. I'll just call it...
-
Lining up group of cell values in Excel 2007 [Solved/Closed]
Hi I have two group of cells D6 to D8 and other G12 to G15 Need a code with two conditions that can line up the details of the mentioned cells...
-
EXCEL [Solved/Closed]
Hello i want to know how to convert date into words(english & HINDI) in excel 2003 or 2007 for eg. 22.04.2010 - convert it into Twenty Two...
-
IF DATE Multiple conditions [Solved/Closed]
Hello, I need help with rewriting this code: =IF(A1DATE(2017,12,31),"2", IF(A1>DATE(2020,12,31), "1"))) I'm trying to categorize those...
-
Fill data according to other sheet's data [Solved/Closed]
I have a sheet1 like this: r1 text1 text 1 r2 text1 textx 2 r2 text1 textx 0 r3 text2 texty 1 r4 text2 textz 1 r5 text2 textx 3 r6 text2...
-
excel-create a compounding interest calculater [Solved/Closed]
I want to work out the after three months dates between two dates ex: 01/03/2013 as the starting date and today date as the last date.
-
Duplicate rows based on cell value [Solved/Closed]
Hi, Can somebody help me out with this. I want to duplicate rows based on input in a cell. can it be done in VB or macro or formula array?...
-
excel payroll work [Solved/Closed]
Hello, I'm using Excel to do payroll system. e.g. I create worksheet that showing data as below table :- basic more than 0.01 less...
-
Excel formular [Solved/Closed]
Hello Sir, Can you let me know the formula in Excel: I have a table as below: 1 A B ...
-
excel greater or less than [Solved/Closed]
Hi all, I'm having a problem that with multi counting with less than, eg. case 1: A1 = 1000 (total revenue) B1 = 3% (rebate) C1 = 2000...
-
Create worksheet based on lists & populate data from another... [Solved/Closed]
Hello, I've been recently working on trying to create a fairly large excel workbook & trying to automatically populate sheets inside of...
-
conditional formatting [Solved/Closed]
hello I did a table in Excel ( its a vacation tracker) I'll give you an example for what i'm trying to do Ex : my vacation starts from 15...
-
Search column B for matching value from a row in column A .... [Solved/Closed]
Search column B for matching value from a row in column A and populate D with the value that is in the matching row of B that was in column C, ie...
-
Compare Column A to Column B and return Column C [Solved/Closed]
Hello, I have spreadsheet with names in Column A, phone numbers in Column B. Column C has the same names in different order. How can...
-
Copying data from one sheet to another conditionally [Solved/Closed]
Hi gang, I have a spreadsheet with columns A thru H being populated with text. I need to copy columns A thru H from spreadsheet 1 to spreadsheet...
-
highlight row on one sheet if a number matches on another sheet [Solved/Closed]
Hello, I have a spreadsheet with multiple tabs. I am trying to figure out how to get a row to highlight on the tab called "Directory" if a number...
-
How to define specific format for number? [Solved/Closed]
Hi, I would like to define specific format in excel. For example, if I type 123456789 and hit Enter, it should be 123-456-789 or 123-45-6789...
-
If statement using date to change row colour [Solved/Closed]
I have a sheet with the following header row: Reference Client MAWB / BoL Date logged Date completed Days to resolve Logged by Caller...
-
Excel 2010-VB Macro formula into many spreadsheets [Solved/Closed]
Hello Everyone, I am new in VB programming and I am trying to write a macro in Excel. Basically, I have written a formula in Excel which enable...
-
IF function using dates [Solved/Closed]
Hi I am trying to write an IF function for an escalation calculation and need some help please. What I want to achieve is to have a date...
-
how do i change the result of a formula to normal text or values [Solved/Closed]
Hello , i have a formula which calculates my working hours for each day " =C9+(B9>C9)-B9 " ... when i try to sum all the hours resulted from that...
-
Excel MMYY format in order [Solved/Closed]
Hello, I have a data set and a column currently with a selection of dates in MYY and MMYY, eg. 909 (Sep 2009) 1011 (Oct 2011) 1212 (Dec...
-
Excel formula help [Solved/Closed]
Hello, I would like to request some assistance with a formula I have been trying to figure out. I know it's a simple one, but it evades my...
-
if cost is 18.66 what would be 0.6% of it (calculation method) [Solved/Closed]
and if basic pay 65000rs what would be the 2.5% of it(calculation method)
-
formulas [Solved/Closed]
sum a column if two other columns contain a specific text each so sum (if (A1:A20=1 and B1:B20 = "A", C1:c20)
-
Copy data from current work to another [Solved/Closed]
Hi All, Please can you help me with the VBA code which copies columns from current active workbook to another closed workbook at the end of...
-
Conditional formatting from another cell by range [Solved/Closed]
Hey, I need helpppppppp i want to change the color of a cell based on the range value of another cell eg. i need a1 to be red if b1 is <...
-
Excel Formula [Solved/Closed]
I need a formula to compute one equation if one criteria OR another criteria is met, and a different equation depending on another...
-
code to move a row based on fix values and paste it [Solved/Closed]
Hello Gurus, This is my 1st question and I m a beginner in macros .I wanted a code to move a row based on a fix values and paste it in the same...
