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, value_
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,
If you are speaking about Status bar that you cant find the sum, Then right
click on Status Bar and select SUM;
Hope ur issue is resolved
Best Regards,
Guru.
On Thu, Jun 17, 2010 at 2:23 PM, anu naik wrote:
> Hey Guys,
> I need help in a matter
>
>
> While using excel ,the sum is display
Hi,
Try using =CONCATENATE(C2&D2) 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
wrote:
> Thanks you. I try your suggestion and give both cell the same format
> but still I get # N/A. The cell I am refering contains
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 wrote:
> Hi,
> Below starts in Cell A1
Hi Uugandhi,
Its better if you could pls attach the file provided its not confidential.
Best Regards,
Haigreev
On 5/12/10, uu 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
> have a VLoo
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 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:
> https://www.y
Hi Chetan,
May be you can Use If condition like below :
=IF(F2>0,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 wrote:
> Can anyone help me on this issue
>
> On Apr 26, 5:
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 wrote:
> Dilipji,
>
> If we need to consider 1st and 3rd Saturday as working, please guide.
>
> Thanks in advance
> Anand
>
> On Mon, Feb 22, 2010 at 11:33
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 wrote:
>
>
> How to skip non working days to calculate number of days betewwn dates
> ??
>
> Such as sunday or any vacations came between working days.
>
>
y compounding).
Your time 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.
Please also note that the details of the venue are mentioned in the attachment.
They will be screening and interviewing on the spot with offers being
given THE SAME DAY.
All this is happening on 20th Feb.
So Hurry up.
On 2/16/10, gurumurthy sastry Kondury wrote:
> Hi All,
>
> I ha
Name: Sastry B
Tip: Using Data List
How? - See attached file
2009/7/6 Ayush :
>
> Dear Members,
>
> Thanks for your great response in the Week 27 competition. It was
> again great learning for the members of the group.
> Let us begin week # 28 quiz with more spirit. Last
do a "Ctrl+["
On 03/07/2009, MF 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,
I have an Excel sheet with VB Project. But I am not able to edit it as this
VB Project is a password protected and the guy created this macro is not
with the Org. rt now.
Could anyone please help me in this regard
Best Regards,
Haigreev
--~--~-~--~~~---~--~~
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
> Use the below code in VB ..open an excel sheet press Ctrl +F11 and inser
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 wrote:
>
>
&
You can use SUMIF function.
2009/5/6 Samir Agayev
> 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 Column D i
e it 5 days 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
> Hi Praveen,
>
> Have see your worksheet. Please use:
> =WORKDAY(B3,
PST CST
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
>
> Hello Everyone,
>
> I have a problem while displaying Time in Pacific Standard Time and
> Central Standard
dsheet* against each respective file name.
Is there any formula that can help me for this?
Thanks & Regards,
Gurumurty Sastry K H
--~--~-~--~~~---~--~~
-
Some important links for e
23 matches
Mail list logo
