Dear experts
I required formula as like Automatic sum for three month.PFA sheet with detailed
Regards
Amar
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
Dear experts,
I have a data in which date format is Text, I want to change in date format
to filter data date and month wise. I have change manually this thing by
pressing FR and Enter key.
Please provide Macro or function to change the format, the example file is
attached herewith.
Regards.
use this formula : CONCATENATE(DAY(C4),-,MONTH(C4),-,YEAR(C4))
On Wed, Jul 16, 2014 at 9:52 AM, Ashish Bhalara ashishbhalar...@gmail.com
wrote:
Dear experts,
I have a data in which date format is Text, I want to change in date
format to filter data date and month wise. I have change
Select one column at a time containing data, then goto Data Text to
column (or just press Alt + D then E).
Select Fixed width press Next 2 time, now select Date existing date
format viz. DMY for Date-Month-Year and press finish.
Cheers!!
On Wed, Jul 16, 2014 at 12:22 PM, Ashish Bhalara
Hello ..
Need urgent help on this please..
Thanks.
On Mon, Jul 14, 2014 at 8:49 PM, pradeep palande bunty5...@gmail.com
wrote:
Okay Pramod.. first of all Thanks for your quick response.
I assume below is the help you needed to move forward on this topic.
- There are 35 to 40 excels in
Oh Thanks to both of you, its very easy...Cheers!!
Regards.
Ashish Bhalara
9624111822
P*Please do not print this email unless it is absolutely necessary. Spread
environmental üawareness.♣♣♣*
On Wed, Jul 16, 2014 at 12:29 PM, Amresh Maurya amreshkushw...@gmail.com
wrote:
see the attachment
Dear Pramod sir,
Can we get the link in exel too. I mean if the link data is pulling the
data from web, than the same link should be capture with respect to its
row.
and than loop to next link, same the running link should be pasted in its
respective rows till all the link is completed pulling
Hi Friends,
I need your help to find common kgid no (like aadhar card no) which is
entered in A,B,C,D .up to n th column (up to n no of section)
i tried conditional formatting, its too slow and not for regular work so i
need macro code.
The problem here is how to find out the kgid Nos
Hi Friends,
I need your help to find common kgid no (like aadhar card no) which is
entered in A,B,C,D .up to n th column (up to n no of section)
i tried conditional formatting, its too slow and not for regular work so i
need macro code.
The problem here is how to find out the kgid Nos who
Yah this can be done I am busy right now .when I have time I must
solve this one..
Pramod
On 16 Jul 2014 12:37, Nitya nityanandadole...@gmail.com wrote:
Dear Pramod sir,
Can we get the link in exel too. I mean if the link data is pulling the
data from web, than the same link
Hi All,
Attached file has two tabs (Raw Data OutCome). What I am trying to
achieve is transposing column F G of the Raw Data onto OutCome tab. The
catch is to transpose basis the role which is listed as heading of Outcome
tab.
If in the list we have more than open person with similar role,
Dear experts, I need your help to populate the cells in the attached
spreadsheet.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use
hi do you want output to be shown in excel sheet?
On Wed, Jul 16, 2014 at 2:10 PM, daya p princedaya2...@gmail.com wrote:
Hi Friends,
I need your help to find common kgid no (like aadhar card no) which is
entered in A,B,C,D .up to n th column (up to n no of section)
i tried
You're welcome!
I just figured that if I simply supplies the formula, there would be some that
would like to see how it came together, so I'd just take care of that right
away!
Paul
-
“Do all the good you can,
By all the means you can,
In all the ways
*Please respond to gurjant.si...@damcosoft.com
gurjant.si...@damcosoft.com*
*Position: QA Tester (Manual UI Tester) (4 positions)Location: Anoka,
MNDuration: Long term*
Best Rate: $40-42/hr MAXX
Note: *Need complete educational details along with two professional
references from two most
I have an excel sheet and i want some cells to be highlighted by some
colors if other 3 cells filled by text.
please see the attached example:
What i mean that Cell A to be highlighted Yellow if Cell A1 filled by text
And to be highlighted Blue if Cell B1 filled by text
And to be highlighted
Hi
There are a lot of commercial software based around Excel for live logging
of incoming data from instruments etc.
Where can I find a site that covers the vba required for receiving data.
Say direct from data recorders and/or thru SMS and a website. That is a
temperature is sent by SMS from a
Hi
Looking for vba requirements for exporting commands (on, off, etc) to a
relay board for control of led lights etc.
Can someone send me in the right direction etc. Do I need an add-in or
activate some controls. Using 2000 at the moment but shortly onto Excel
2013.
Thankyou
Charles
Hi Charles,
To interface with the 'outside world' as such you need to have a method of
communication. Typically you would use something like a serial or network
interface to send / receive commands to a programmable logic controller
(PLC) and the controller would then do the actual work of
Pramod,
Would you have any idea why it stops ?
On Monday, July 14, 2014 7:16:58 AM UTC-4, Bill Q wrote:
A great first effort Pramod. I called it up a few times. I always get the
same 3 first lines returned - then I get the following error from your code
and it stops:
wk.Cells(i,
Hi,
Thanks for your response. I have spent a little while going over the code
to figure out what is going on. I really like the filename parsing for
determining what column to put data in. That will be very useful. I don't
think I explained the consolidating objective well enough and I am
Hi Bill,
The website is so heavy so it is taking lot of time to load .I am also
working on it from another method.
Regard
Pramod
On Thu, Jul 17, 2014 at 7:23 AM, Bill Q ronsmith...@gmail.com wrote:
Pramod,
Would you have any idea why it stops ?
On Monday, July 14, 2014 7:16:58 AM
Sir,
thanks a lot
it is very helpful to me my friends to work easy
to complete work within seconds
thank you ince again
from:
Daya
On 16 July 2014 19:08, Vaibhav Joshi v...@vabs.in wrote:
Refer this.. i made it more dynamic!
Cheers!!
On Wed, Jul 16, 2014 at 6:43 PM, Vaibhav Joshi
23 matches
Mail list logo