of the product based on that.
Any ideas as to how to crack it?
regards,
Sastry
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
Hi Rajesh,
If your question is to use the function in one Cell ( Say B1) and to show
the description of the Function in the next cell ( say C1) , then use your
function in Cell B1, and put the same function in Cell C1 leaving one space.
See Example below
=IF(logical_test, value_if_true,
Hi,
I have a complete column like the below which has a reference number, a text
and two values for the text. I want to split this data into four different
columns ( B C D E). Please help.
1.01 Vinculados a Compromissos de Recompra 726.223 300.412
Thanks Regards
Guru.
--
Hi,
Try using =CONCATENATE(C2D2) in Column E and then the Vlookup in F.
It should work.
Best Regards,
Guru.
On Thu, Jun 17, 2010 at 2:54 PM, Regina Medhanie
regina.medha...@gmail.comwrote:
Thanks you. I try your suggestion and give both cell the same format
but still I get # N/A. The cell
Hi dave,
In the same way If I want to know the exact number of working hours between
19:45 PM yesterday and 16:50PM today ( Considering the user is working in
second shift from 15:00 PM to 00:00 AM ).
Thanks Regards,
On Thu, Jun 17, 2010 at 7:33 AM, who dlanm...@att.net wrote:
Hi,
Below
Hi Uugandhi,
Its better if you could pls attach the file provided its not confidential.
Best Regards,
Haigreev
On 5/12/10, uu uugan...@gmail.com wrote:
What I would like is under column D to be able to select one store
number at a time from the data sort filter. What I would like to do
is
Hi,
Just see the attached file and confirm If this is what you are looking for.
Best Regards,
Guru
On Tue, May 4, 2010 at 8:57 PM, dza7 dvpe...@gmail.com wrote:
Hello,
I have a challenging pivot table issue that I hope I can get some help
on.
Here is the spreadsheet I'm working with:
Hi Chetan,
May be you can Use If condition like below :
=IF(F20,1,0) - If the entry is in cell F2. Cuz you put any value more
than 1, it will give you only 1 as required.
Hope this works.
Best Regards,
Haigreeva.
On 4/28/10, Chetan chetu...@gmail.com wrote:
Can anyone help me on this issue
Hi Anand,
You just add +2 to the end of the formula ( In this attachment in Cell C5).
Guru.
On Tue, Feb 23, 2010 at 8:50 AM, Anand Desai a4an...@gmail.com wrote:
Dilipji,
If we need to consider 1st and 3rd Saturday as working, please guide.
Thanks in advance
Anand
On Mon, Feb 22,
You can use the network days function.
Please tell me if it clarifies your doubt.
Guru
On Mon, Feb 22, 2010 at 5:37 PM, Abdul Rasheed rashee...@gmail.com wrote:
How to skip non working days to calculate number of days betewwn dates
??
Such as sunday or any vacations came between
and thoughts would be highly appreciated.
Sastry
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http
do a Ctrl+[
On 03/07/2009, MF michael.fendr...@gmail.com wrote:
Anyone know how to toggle to a cell in a formula?
For example
if a cell contains the formula =A4*B7, that this toggle will take
you to cell A4.
i was hoping for a quicker way to do this than Formula Auditing.
Thanks
Name: Sastry B
Tip: How to use a combo box. (Excel attached for clarity)
This must be very useful for all those who are in MNCs and have to show
their financial/economic nos. in more than one currency. This comes
extremely handy.
I have written the core tip in this attachment. You can put more
Hi Surya,
I too get some files for which I do not have a password. After Alt+F11, I
can neither open a new module or place to write anywhere.. how shall I go
about?
regards,
Sastry
2009/5/19 Surya - Chantigadu suryaprasad...@gmail.com
Use the below code in VB ..open an excel sheet press Ctrl
Hi All,
Please note that the below attachment is working fine. But when there is not
attachment, then If the cells ( Attachment Doc ) are blank then the body
is found missing in the mail.
Please help.
Thanks Regards,
Gurumurty Sastry K H
On 4/10/09, Subu pns...@gmail.com wrote
You can use SUMIF function.
2009/5/6 Samir Agayev saga...@gmail.com
Dear Group members,
In attached excel file, I have a little vba code.
It gets data from Column B in Sheet2 to Column D in Sheet1 if Column D in
Sheet2 equals Column A in Sheet1.
The only problem occurs when the Items of
and the work ends on a Sunday which is weekend, which
is not correct.
I am quite novice as compared to many guys in this group. Would appreciate
your thoughts.
Regards,
Sastry
2009/4/30 Aindril De aind...@gmail.com
Hi Praveen,
Have see your worksheet. Please use:
=WORKDAY(B3,F3)-1 in cell D3
Row 2 2009/4/29 18:59:10=A2+2/24
this should show as 2009/4/29 20:59:10 (i.e.,
adding 2 hrs)
regards,
Sastry
jamadagnira...@gmail.com
Hello Everyone,
I have a problem while displaying Time in Pacific Standard Time and
Central Standard Time
18 matches
Mail list logo