The discussions

Round up formula for time

 Solved

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-Apr-...

2 replies Last reply on 1 May 2014 by
ravibangera

The value of a name

 Solved

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 making ...

2 replies Last reply on 29 Apr 2014 by
Derrall

Can the formula counta / count exclude 0 values?

 Solved

If I use COUNT or COUNTA, what can I include in the formula to exclude zero values? Thanks for any tips

2 replies Last reply on 28 Apr 2014 by
doublewitt

Transfer data into invoice

 Solved

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 dur...

10 replies Last reply on 28 Apr 2014 by
semperfi90

Inserting a row when the value of a field changes

 Solved

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 Long '...

2 replies Last reply on 28 Apr 2014 by
KKautz

Format cell color based on date range

 Solved

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 backgroun...

4 replies Last reply on 27 Apr 2014 by
doublewitt

Filtering data from 1 sheet to another

 Solved

Hello, I have the following problem. Kindly help me with the same: Problem statement: I have data pertaining to projects, milestones and tasks ...

2 replies Last reply on 24 Apr 2014 by
mmtmacros

To show blank record when no data while copying

 Solved

Hello, I have three sheets sheet1(Active) ,Sheet 2(Inactive) and Sheet3(Total). I have written code which would copy data from Active sheet ,th...

4 replies Last reply on 22 Apr 2014 by
venkat1926

Add value to one cell if multiple other cells have any value

 Solved

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 to t...

11 replies Last reply on 21 Apr 2014 by
alonsy

Conditional formatting for cells depending on other cells ranges

 Solved

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 green ce...

3 replies Last reply on 16 Apr 2014 by
Derrall

How to see if a particular cell in a table has date data or not

 Solved

Hello, I am preparing a tracking tool to measure the life of an item. The table has Installation No Date 1 ...

4 replies Last reply on 16 Apr 2014 by
vinaymaithani

Highlight the linked cell depends on drop-down list choice

 Solved

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 "Asses...

2 replies Last reply on 14 Apr 2014 by
Natasyamn

Conditional formatting: merged cell color

 Solved

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 information th...

2 replies Last reply on 14 Apr 2014 by
ricky588

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 compare...

Last reply on 11 Apr 2014 by
ac3mark

Excel: partial matches in 2 different cells

 Solved

Hello, I've been mulling over this all afternoon and need some help. Here is what my sheet looks like: K L 3 ...

2 replies Last reply on 10 Apr 2014 by
kaiwalls04

Determine percentage via formula

 Solved

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 determi...

3 replies Last reply on 8 Apr 2014 by
kaiwalls04

Two values to find on the same cell

 Solved

Hi, Can the below be shorten up? It's basically to count if "dr" or "ba" are in cell E2180; =IF(ISNUMBER(SEARCH("(dr)",E2180)),"1",IF(ISNUMBER(SEA...

2 replies Last reply on 7 Apr 2014 by
jutulu

Macro to delete row after certain condition found

 Solved

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 the...

6 replies Last reply on 4 Apr 2014 by
wendelly

If then (text or no text)

 Solved

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 "6.2"...

4 replies Last reply on 4 Apr 2014 by
hikkup

Connect two worksheets together

 Solved

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. Ther...

2 replies Last reply on 3 Apr 2014 by
rookie

Conditional formatting: highlight cells based on two values

 Solved

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 "C5" f...

2 replies Last reply on 2 Apr 2014 by
Plastic_Cup_of_Stars

Lining up group of cell values in excel 2007

 Solved

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 in ...

7 replies Last reply on 31 Mar 2014 by
TrowaD

Excel

 Solved

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 April...

2 replies Last reply on 31 Mar 2014 by
JasminBarby

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 date ...

Last reply on 27 Mar 2014 by
beejive

Fill data according to other sheet's data

 Solved

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 text...

6 replies Last reply on 20 Mar 2014 by
Migas.pt

Duplicate rows based on cell value

 Solved

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? User wi...

16 replies Last reply on 13 Mar 2014 by
TrowaD

Excel payroll work

 Solved

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 tha...

4 replies Last reply on 12 Mar 2014 by
Winndixie

Excel formular

 Solved

Hello Sir, Can you let me know the formula in Excel: I have a table as below: 1 A B ...

9 replies Last reply on 11 Mar 2014 by
TrowaD

Excel greater or less than

 Solved

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 (free ...

2 replies Last reply on 10 Mar 2014 by
Winndixie

Create worksheet based on lists & populate data from another...

 Solved

Hello, I've been recently working on trying to create a fairly large excel workbook & trying to automatically populate sheets inside of it. I h...

5 replies Last reply on 10 Mar 2014 by
sv2bnv

Conditional formatting

 Solved

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-mar ...

9 replies Last reply on 10 Mar 2014 by
Mazzaropi

Search column b for matching value from a row in column a ....

 Solved

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 XYZ ...

10 replies Last reply on 7 Mar 2014 by
ac3mark

Compare column a to column b and return column c

 Solved

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 I ha...

2 replies Last reply on 6 Mar 2014 by
ad1959

Copying data from one sheet to another conditionally

 Solved

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 2 i...

2 replies Last reply on 5 Mar 2014 by
sorceres13

Highlight row on one sheet if a number matches on another sheet

 Solved

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 in ...

10 replies Last reply on 4 Mar 2014 by
TrowaD

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 autom...

Last reply on 4 Mar 2014 by
ugn10

If statement using date to change row colour

 Solved

I have a sheet with the following header row: Reference Client MAWB / BoL Date logged Date completed Days to resolve Logged by Caller type Error ar...

2 replies Last reply on 3 Mar 2014 by
Z Kindo

Excel 2010-vb macro formula into many spreadsheets

 Solved

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 me ...

4 replies Last reply on 3 Mar 2014 by
AnFey

If function using dates

 Solved

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 filled ...

2 replies Last reply on 28 Feb 2014 by
Escalation

How do i change the result of a formula to normal text or values

 Solved

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 for...

8 replies Last reply on 26 Feb 2014 by
kelnasawa

Excel mmyy format in order

 Solved

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 2012...

5 replies Last reply on 24 Feb 2014 by
nickkyh

Excel formula help

 Solved

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 mind. ...

5 replies Last reply on 19 Feb 2014 by
ac3mark

If cost is 18.66 what would be 0.6% of it (calculation method)

 Solved

and if basic pay 65000rs what would be the 2.5% of it(calculation method)

5 replies Last reply on 17 Feb 2014 by
nooblord

Formulas

 Solved

sum a column if two other columns contain a specific text each so sum (if (A1:A20=1 and B1:B20 = "A", C1:c20)

2 replies Last reply on 14 Feb 2014 by
Gmooney

Copy data from current work to another

 Solved

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 rows.....

2 replies Last reply on 14 Feb 2014 by
Sush

Conditional formatting from another cell by range

 Solved

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 < 70%, Y...

1 reply Last reply on 13 Feb 2014 by
ac3mark

Excel formula

 Solved

I need a formula to compute one equation if one criteria OR another criteria is met, and a different equation depending on another criteria If nu...

2 replies Last reply on 10 Feb 2014 by
meesh97

Code to move a row based on fix values and paste it

 Solved

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 shee...

2 replies Last reply on 8 Feb 2014 by
sonkar

Simple macro

 Solved

I am trying to create a Macro to filling in a series of columns starting with the current cell. simply if cell A1 is selected and you hit the ...

2 replies Last reply on 7 Feb 2014 by
warnerjs

Fill amount from a cell if date is before end of month

 Solved

Can someone please help. I'm trying to track outstanding bills due by the end of month as in the following example: If date in cell B5 (due date) i...

4 replies Last reply on 6 Feb 2014 by
hawkwms
Results 901 - 950 out of a total of 1,690