You can use a lot of differents methods to obtain this kind of information using Excel.

Funtions:

VLOOKUP

INDEX + MATCH

INDIRECT

and others.

To indicate a good solution for you is TOTALLY necessary to know about layout of your file.

Save a portion of you file at a free site , putting here a link to download.

Make sure you have data enough at file and put there how you desire the answer appears.

thanks,

Statistics: Posted by Jill R. Lipe — Wed Nov 26, 2014 10:59 am

]]>

I have six month excel attendance sheet. which formula can i use to know in which month which of the employee has left and who has joined ?

Any suggestion.

Statistics: Posted by Bryan L. Warfield — Thu Nov 20, 2014 10:01 am

]]>

=IF(J4<=H4,"PASS",if(J4>H4,"FAIL",if(J4=0,"N/A")))

BUT these conditions are not correct. For exampls if J4=0 can it be <H4 ? If yes you will get" PASS" not "N/A". If H4<0 and J4=0youill get " FAIL" not "N/A".

You need to review your conditions in the light of possible values.

Please try the code given below:

- Code:
`=IF(J4=0,"N/A",IF(J4<=H4,"PaSS","FAIL"))`

Thanks,

Statistics: Posted by Micheal T. Leo — Mon Sep 15, 2014 12:06 pm

]]>

I cannot get this formula to work and have tried everything I can think of, please help =IF(J4<=H4,"PASS")OR(J4>H4,"FAIL")OR(J4=0,"N/A")

Please help me..

Thanks in Advance,

Statistics: Posted by Champ_AN — Mon Sep 15, 2014 6:24 am

]]>

Excel got a function COLUMN() you can use:

=COLUMN(AS1)-COLUMN(O1)

I hope this will help you.

Thanks,

Statistics: Posted by MikeLON — Sat Aug 23, 2014 8:58 am

]]>

Is it possible to count the number of columns between two identified columns ? I don't want to know whats in cells, just how many columns there are.

E.g. how many columns are between (and not including) the columns O and AS ?

Any idea how can i do it

Thanks in advance,

Statistics: Posted by Tansenn — Thu Aug 21, 2014 7:08 am

]]>

Recently i received e mails with a power point viewer presentation will not open in Open Office but reverts to Microsoft Office page that requires a purchase or subscription to MS office .

Is there a fix for this problem ??

Thanks in Advance,

Statistics: Posted by Brian L. Chacon — Fri Aug 08, 2014 9:43 am

]]>

For the data you posted, and depending on whether you want to keep the final period, either:

=IF(ISERROR(FIND(".",A1)), LEFT(A1,LEN(A1)-1), LEFT(A1,LEN(A1)-2))

or:

=IF(ISERROR(FIND(".",A1)), LEFT(A1,LEN(A1)-1), LEFT(A1,LEN(A1)-3))

Thanks

Statistics: Posted by Gregory A. Chase — Tue Jul 29, 2014 11:05 am

]]>

I have over 10,000 entries of part numbers with variable lengths for example

(1) 000

(2)00.00

(3)00.00.00

the rule I need is if the cell has a "." need to remove 2 from the right and if it has no "." need to remove 1.

Can anyone think of a formula that could do this, I have tried Left & Right Function but it only works to a certain degree.

Thanks in Advance,

Statistics: Posted by Brian L. Chacon — Tue Jul 29, 2014 7:21 am

]]>

I am getting better with these if statements, this one is causes my brain to come to a screeching halt.

I have a sheet that could contain 2 dates on the same row. I need to calculate the number of days remaining depending on what is in the blocks.

Thanks.

Statistics: Posted by SteveJ — Sat Jun 07, 2014 12:12 pm

]]>

- Code:
`Sub AddFormulasToComments()`

Application.ScreenUpdating = False

Dim CommentRange As Range, TargetCell As Range

'skip over errors caused by trying to delete comments in cells with no comments

On Error Resume Next

'If the whole worksheet is selected, limit action to the used range.

If Selection.Address = Cells.Address Then

Set CommentRange = Range(ActiveSheet.UsedRange.Address)

Else

Set CommentRange = Range(Selection.Address)

End If

'If the cell contains a formula, turn it into a comment.

For Each TargetCell In CommentRange

With TargetCell

'check whether the cell has a formula

If Left(.Formula, 1) = "=" Then

'delete any existing comment

.Comment.Delete

'add a new comment

.AddComment

'copy the formula into the comment box

.Comment.Text Text:=.Formula

'display the comment

.Comment.Visible = True

End If

End With

Next

MsgBox " To print the comments, choose" & vbCrLf & " File|Page Setup|Sheet|Comments," & vbCrLf & "then choose the required print option.", vbOKOnly

Application.ScreenUpdating = True

End Sub

Thanks

Statistics: Posted by Champ_AN — Mon May 12, 2014 10:37 am

]]>

Thanks

Statistics: Posted by Tansenn — Mon May 12, 2014 9:16 am

]]>

I searched the Forum but I didn't find anything about it.

How is it possible to copy data and paste them into a comment in a specific cell?

Once in a week I have to fill 10x7=70 comments in cells of an Excel file with a lot of data that I get from an other excel file.

This work takes a lot of time entering manually all data!! I was wondering if it is possible to simplify this work.

Thank you in advance for your help.

Statistics: Posted by MikeLON — Mon May 12, 2014 7:49 am

]]>

Thanks,

Statistics: Posted by UniSET — Mon May 12, 2014 5:41 am

]]>

Perhaps you should consider using a worksheet template. See: http://www.ehow.com/how_13117_create...-template.html

Statistics: Posted by LiverPAN — Mon May 12, 2014 5:35 am

]]>