PFA
On Tue, Aug 9, 2016 at 11:11 AM, 'LAKSHMAN PRASAD' via MS EXCEL AND VBA
MACROS wrote:
> Dear Expert,
>
> please help me out lookup and sum from sheet2
>
> regards
> LAKSHMAN
>
> --
> 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 offici
=lower(a1)
A1 is your first value, then you can drag.
On Monday, August 8, 2016, sourav devrani
wrote:
> A
>
> B
>
> C
>
> D
>
> How to small these values using Small Formula.
>
> --
> 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 officia
Please send your sample txt file as attachment.
On Sun, Jul 31, 2016 at 6:46 PM, Puttu * wrote:
> any help please :(
>
> On Sat, Jul 30, 2016 at 10:19 PM, Puttu * wrote:
>
>> Some one look and help on this please
>>
>> On Sat, Jul 30, 2016 at 12:16 PM, Puttu * wrote:
>>
>>> Experts... plea
Under Condition Formatting Tab, I have put 2 conditions. Please see under
Conditional Format > Manage Rules
Screenshot attached.
On Sat, Jul 30, 2016 at 12:55 PM, Sanjib Chatterjee <
chatterjee.kolk...@gmail.com> wrote:
> Abhishek Jain,
>
> Many Many thank you for solving
On Fri, Jul 29, 2016 at 4:13 PM, Sanjib Chatterjee <
chatterjee.kolk...@gmail.com> wrote:
>
> Dear All
>
> Please see the attachment and solve the problem .
>
> Sanjib
>
>
>
> --
> -
>
> --
> 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 off
Why not just use pivot ?
On Fri, Jun 3, 2016 at 8:35 PM, Prabhakar S H
wrote:
> Hi Friends,
>
> I have Employee database where data is in raw & i need in column. Please
> refer attached file & help.
>
>
> Rgds,
> Prabhakar
> 9844430518
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And
Please share an example workbook.
On Fri, May 27, 2016 at 3:10 PM, Louis Omoya wrote:
> Hi all? Thid is my first post in the group. I appreciate the support
> online communities such as this offer.
>
> To my problem (which i have spent 2 days with no success).
>
> I have a column of regions and
Plz see attached
On Thu, May 26, 2016 at 5:26 PM, Vaibhav Joshi wrote:
> Dear Experts
>
> I want to calculate gratuity for employees.
> I want to know difference between date of joining & date of leaving in no
> of years completed, no of months completed & no of days (in exact terms)
>
> for eg
Please see attached
On Wed, May 25, 2016 at 4:43 PM, André D'Avila
wrote:
> Hello Experts!
>
> I have a cell containing the info "Invoice Google Nr 123456789" and
> another containing "Invoice Twitter Nr 1234567" for exemple.
>
> And I have a list of keywords that I named "keywords" like below:
mount which needs to
> be reconciled with my ledger account ensuring amount received for all lines
> which mentioned. awaiting your help.
> I would be having only amount column similar for both vendor & ledg so pls
> help me out.
>
> Thanks,
> Regards.
>
> On W
;
> Limit for 900
>
> On 24 May 2016 at 12:27, Abhishek Jain wrote:
>
>> Please explain a bit more what exactly do you need.
>>
>> On Tue, May 24, 2016 at 12:09 PM, Shaikh Iqbal
>> wrote:
>>
>>> Hi,
>>>
>>> Anybody help me !
>&
Please explain a bit more what exactly do you need.
On Tue, May 24, 2016 at 12:09 PM, Shaikh Iqbal
wrote:
> Hi,
>
> Anybody help me !
>
>
>
> -- Forwarded message --
> From: Shaikh Iqbal
> Date: 23 May 2016 at 19:55
> Subject: $$Excel-Macros$$ Need - Formula weekly bonus
> To: e
http://www.get-digital-help.com/2012/07/18/create-links-to-all-sheets-in-a-workbook/
On Fri, May 13, 2016 at 3:06 PM, Pravin Gunjal wrote:
> Hi Friends,
>
> I have 48 sheets in a file and have one summary sheet in the beginning of
> the same file.
>
>
>
> I would like to use hyperlink in summary
In all but one of your examples, the number you want to extract appears
right after the text "_POV_" for which you can use the following formula -
=MID(A1,FIND("_POV_",A1)+5,1)
It will extract ONE character AFTER the text _POV_
HTH
On Thu, May 5, 2016 at 11:24 AM, Izhar wrote:
> LOOK AT THE
PFA.
When you make other cells bold, be sure to hit the F9 button to
re-calcualte.
HTH
On Thu, May 5, 2016 at 11:12 AM, Sushma David wrote:
> Hi Champs,
>
> Please solve this query.
>
>
>
> Regards,
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,D
ll.
>
> Pravin.
>
>
> *With regards,**Pravin Gunjal*
> *Mobile: 77100 *
> *97250*
>
>
>
>
> On Mon, May 2, 2016 at 6:07 PM, Abhishek Jain
> wrote:
>
>>
>> http://www.mrexcel.com/forum/excel-questions/518757-delete-all-macros-workbook.html
>>
http://www.mrexcel.com/forum/excel-questions/518757-delete-all-macros-workbook.html
On Mon, May 2, 2016 at 5:41 PM, Pravin Gunjal wrote:
> Hi, Good Evening
>
> I would like to know whether is there any provision to remove all macros
> from all the excel files on a computer?
> Kindly share your i
To me, if you just want to "match" the simplest option would be to use a
pivot table. Copy all you ledger numbers in a column. put the locations in
another and draw a pivot.
Attached is an example.
HTH
On Fri, Apr 29, 2016 at 11:39 PM, Cute Awesome
wrote:
> Dear All,
> I'm unable to have exact
ch 04 L1. Xlsx
>
> Pls suggest
> On Apr 28, 2016 11:02 AM, "Abhishek Jain" wrote:
>
>> In your first macro, instead of:
>>
>> Workbooks.Open (MyFile)
>>
>> use:
>>
>> Workbooks.Open (path & MyFile)
>>
>> HTH
>>
>>
In your first macro, instead of:
Workbooks.Open (MyFile)
use:
Workbooks.Open (path & MyFile)
HTH
On Thu, Apr 28, 2016 at 9:26 AM, Secret Shot wrote:
> Hi all,
>
> Can anybody pls look into it. I am really hoping that I will get
> resolution from this forum.
> On Apr 28, 2016 1:35 AM, "Secre
Try searching for something like "screen capture with effects"
BTW, the TNT Screen Capture tool has paper-tear effects like the one in
your example.
On Wed, Apr 27, 2016 at 12:31 PM, Pravin Gunjal wrote:
> Dear Friends,
>
> This is apart from excel knowledge, I would like to know to how to ta
Please see attached.
It gets the result from an UDF so be sure to copy the function as well if
you intend to use it in another file.
HTH
On Tue, Apr 26, 2016 at 4:22 PM, Neeraj Chauhan
wrote:
> Dear sir,
>
>
>
> I want all Indus id in one row with Comma
>
>
>
> *INDUS ID*
>
> *INDUS ID*
>
> I
Try this:
1. Right-click a cell in the pivot table
2. Click on PivotTable options
3. Click on the Data tab
4. In the Retain Items section, select None from the drop down list.
5. Click OK, then refresh the pivot table.
On Mon, Apr 25, 2016 at 12:54 PM, Pravin Gunjal wrote:
> Not
a lot for your response.
>
>
> On Tue, Apr 19, 2016 at 9:23 AM, Abhishek Jain
> wrote:
>
>> Sorry I am unable to understand your query.
>>
>> If the value is same in Col A and Col B, your formula is correctly
>> displaying in Col C.
>>
>> What exactly
Sorry I am unable to understand your query.
If the value is same in Col A and Col B, your formula is correctly
displaying in Col C.
What exactly do you want?
On Tue, Apr 19, 2016 at 11:15 AM, Rajeev Kumar wrote:
> Dear Experts,
> Please look in to the attached sheet and please tell me formula
Some part of your query is not clear. Please give a sample output as to
what exactly you want.
Rgds,
On Fri, Mar 25, 2016 at 7:10 PM, Cute Awesome wrote:
> Dear All,
>
> Pls help me out in matching two columns wherein i'll be having cost of
> products which i have send back to supplier and in o
Please see attached.
HTH
On Wed, Mar 2, 2016 at 10:28 AM, amar takale wrote:
> Dear Paul Sir
>
> Pls look into this topic.I think we will use (If+Search) formula but I
> cant possible how to modified it.
>
> Regards
> Amar
>
> On Mon, Feb 29, 2016 at 7:49 PM, amar takale wrote:
>
>>
>> --
>> A
Dear Amar,
To me this seems to a wordart object, you can re-create it and try to make
as similar as possible or change it all the way to your likings.
Please see a sample attached. Under the Format tab, you can change it as
you may like, including the text.
HTH
On Wed, Mar 2, 2016 at 10:25 AM,
=IF(G:G<>"",MONTH(G:G),"")
HTH
On Mon, Feb 8, 2016 at 12:28 PM, James Johnston
wrote:
> Hey guys, I am creating a budget. I set up a google form to enter
> expenses and now am trying to create the backend.
>
> So far I have one sheet for the transactions automatically filled when I
> use the f
Look at the second name "Carme" in your sheet.
Your formula is picking up the first 02 digits of the DOB and taking them
as 'month' and there is no 16th month in the calender.
You either need to change your formula or the dates themselves.
HTH
On Sat, Feb 6, 2016 at 2:50 PM, amar takale wrote:
Does this help?
On Wed, Feb 3, 2016 at 11:54 AM, Vijayendra Rao
wrote:
> Dear Expert,
>
>
>
> I have time sheet which is received from my team and I tried to extract
> data in to separate columns. I have tried with combination of formula of
> “left, mid, right, find” but still it is not coming
Something like this: ?
https://exceljet.net/formula/count-unique-values-in-a-range-with-countif
On Sun, Jan 31, 2016 at 9:45 AM, Theresa Welton
wrote:
> Unfortunately, that is not what I am looking for. I have employees
> participating in activities, these activities are recorded one in each r
Do you already have the list of unique ids or you want to create it?
As for the counting part, there are more than one ways to achieve this -
based on type of data and how it is stored.
For better understanding, a sample workbook with what you have and what you
want will help.
However, anywhere
).If sheet name is AAA then in M16 it should be AAA
>
> Thanks once again for great help
> Regards
> Shrinivas
>
> On Sat, Jan 23, 2016 at 1:45 PM, Abhishek Jain
> wrote:
>
>> Open the attached file.
>>
>> Please note that you can only run this macro only o
Open the attached file.
Please note that you can only run this macro only once because when you do
it again, it will already have the sheets created with those names and
hence would give you an error.
I gathered that you need it likewise (make copies once). If you want
further copies, just change
=PROPER(A1)
Drag down!
On Fri, Jan 22, 2016 at 12:18 PM, Vinod Kumar wrote:
> Dear Team,
>
> Pls. asst. how to change first letter of a word to Cap's, in multiple cell.
>
> --
> 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 Faceb
Change the code to this:
Private Sub Workbook_Open()
ActiveWorkbook.CustomViews("TODAY'S BIRTHDAY").Show
Application.Wait (Now + TimeValue("00:00:10"))
ActiveWorkbook.CustomViews("ALL PERSONS").Show
End Sub
Change the highlighted time delay as per your need.
On Fri, Jan 15, 2016 at 8:52 AM, b
I assumed that by 'cursor' you mean cell pointer.
I couldn't understand in what context you referred to name manager as I
don't see any named range as 'CAL' in your file.
What I gathered is that whenever you open this file, you want your cell
pointer on a specific cell on a specific sheet. Excel
Please see if this solves your purpose -
http://www.vbaexpress.com/kb/getarticle.php?kb_id=837
On Mon, Jan 11, 2016 at 11:55 AM, Kat wrote:
> Hi Abhi,
>
> In terms of revision times, I want to show all the current revision times.
> Also, in the future, if there is any revision times being updat
Please elaborate what do you mean by "revision times". Do you want to show
the time when it was most recently updated or you want to show how many
times has it been updated?
On Mon, Jan 11, 2016 at 9:52 AM, Kat wrote:
> Hi all,
>
> I want to create a xlsm file which list out the folder name, f
When you are subtracting, you are excluding the start date.
On Mon, Jan 11, 2016 at 10:30 AM, Izhar wrote:
> Please open the attachment see the question.
> Thanks in advance.
>
> --
> 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 officia
Hi
Plz share a sample workbook.
On Sunday, January 10, 2016, Ahmed Emam wrote:
> Dear All members,
>
> I have an excel sheet which being extracted from a fingerprints device
> that shows all dates employees had put their fingers already to prove their
> presence.
>
> My request is how to make
In your formula, you can add* &CHAR(10)* wherever you want to have an
"Alt-Enter". You also need to format your output cell for "wrap - text" to
have correctly separated lines.
For spell check, you can use the built in spell checker in Excel from
the *Review
tab*, short cut key is *F7*. I am afrai
d in cell a1 and qty in cell b1.
> But shelf life of material is only 15 days so i want to highlight that
> once the 15 days over
> I cant put formula in B1 so I want conditional formating
>
>
> Regards
> Shrinivas
>
>
> On Thu, Dec 31, 2015 at 12:26 PM, Abhishek Jain
You can use below formula in B1 and set desired format. Then copy B1 and
select rest of the cells where you want the formatting and use Paste
Special > Formats.
*=AND(A1<>"",A1<=TODAY()-15)*
On Thu, Dec 31, 2015 at 11:50 AM, Shrinivas Shevde
wrote:
> Dear all
> One small query.
> I have a dat
Dear Rajeev,
Please see attached.
User 1 -
ADMIN
admin123
User 2
GUEST
guest123
*Both user names and passwords are case-sensitive.*
HTH, Abhishek
On Wed, Dec 30, 2015 at 1:11 PM, Rajeev Kumar wrote:
> Please find attached file and help as per requirement.
>
> Thanks in advance
>
> On Wed,
Please share sample of your worksheet and mention what textboxes you want
to be disabled in Guest mode.
Rgds, Abhishek
On Wed, Dec 30, 2015 at 11:08 AM, Rajeev Kumar wrote:
> Dear Experts,
> I am here by requesting for an sampel workbook for following: -
> 1) When open a workbook, it should po
u can,At all the times you can,To all the people
> you can,As long as ever you can.” - John Wesley*
> -
>
> --
> *From:* Abhishek Jain
> *To:* Paul Schreiner
> *Sent:* Thursday, November 5, 2015 7:25 AM
> *Subje
t 6:55 PM, big smile wrote:
>
>> Thanks a lot
>>
>> But if i put Table A then it shows 0 only. For Table A -- Both Risk Group
>> I /II not work..
>>
>> On Thu, Nov 5, 2015 at 6:49 PM, Abhishek Jain
>> wrote:
>>
>>> PFA
>>>
>
PFA
On Thu, Nov 5, 2015 at 6:20 PM, big smile wrote:
> Repected Friends 1] Which formula I should use in E 13 --- I want the
> value depends upon Risk Group & Table As per B4 :D9 2] First I have to
> see the Group which I & II then Table A/B/C/D It will take depends upon
> this two criteria
Thanks Mandeep ji,
I do know that cell has a limit of characters, but my each returning value
has only 3 characters and max possible matches are 10 per lookup value, so
the maximum characters per cell would be 30. I guess that's not the issue
there.
Nevertheless, I would look into the alternate y
Hi All,
I intend to use this piece of UDF I found on internet for my requirement -
Function MYVLOOKUP(lookupval, lookuprange As Range, indexcol As Long)
Dim r As Range
Dim result As String
result = ""
For Each r In lookuprange
If r = lookupval Then
result = result & " " & r.Offset(0,
Dear Praveen,
Paul has already provided solution to your query.
Thanks & regards,
Abhishek
On Tue, Oct 27, 2015 at 12:57 PM, Pravin Gunjal wrote:
> Hi Friend
> could you plz helm me out on the issue.
> Thanks in advance.
>
> Regards
> Pravin Gunjal
> -- Forwarded message --
>
PFA...
On Mon, Oct 26, 2015 at 4:02 PM, Pravin Gunjal wrote:
> Dear Friends
>
> I have attached an excel file in which I have used macro to get "Created
> by" field automatically once the values are entered in column N (Qty).
> Likewise I want the last column (Entry Date) to be updated as curren
Yes, we can.
On Sun, Oct 4, 2015 at 3:47 PM, PRADEEP KUMAR KOKNE <
pradeepkumar...@gmail.com> wrote:
> Hello all,
>
> Can you write code for to filter(Column S)-> select the complete visible
> data and paste it in new workbook and save it.
>
> Example: Column S can have 50 lines data with 10 name
ote:
>
>> Hello Abhishek
>>
>> That's pefect! Thank you so much for your quick response
>> Regards
>> Nyree
>>
>>
>> On 19-Sep-15 2:20 PM, Abhishek Jain wrote:
>>
>> Please see attached
>>
>> HTH, Abhishek
>>
>>
Please see attached
HTH, Abhishek
On Sat, Sep 19, 2015 at 5:31 PM, N .williams
wrote:
> Hello
> I would like to know if its possible to use a macro or forumula to replace
> every "0" with the header cell value and list each one by student
> eg Student B: Q107, Q108, Q110
>
> Many thanks for yo
See if this helps -
http://www.maheshsubramaniya.com/article/fix-for-code-execution-has-been-interrupted-in-excel-vba-macros.html
On Sat, Sep 19, 2015 at 3:04 PM, Pravin Gunjal wrote:
> Hi, Can anyone help me on this subject?
>
> On Saturday, September 19, 2015 at 1:45:12 PM UTC+5:30, Pravin Gu
http://www.excel-easy.com/examples/compound-interest.html
On Sat, Sep 19, 2015 at 11:29 AM, Rajesh Agarwal wrote:
> Rs. 1/-
> rate of interest 12%
> compound half yearly, quartly, monthly for the period of
> 1. 15 months
> 2. 267 days
>
> --
> *Rajesh Kumar Agarwal*
> *9811063001*
Just to clear it up...1 "lakh" rows mean 100,000 rows.
On Wed, Sep 16, 2015 at 5:16 PM, Suman wrote:
> Dear Paul,
> I can understand macro and modify too according to needs while
> implementing in my workbook. You can make the module on the basis of my
> previous attachment. Secondly, 1 lack d
You can simply deduct the times - like (in F2):
=E2-D2
You can then set the format of the result to as "[hh]:mm" - without quotes
and drag / copy as required.
PS: Have a look at your values showing as "0:00" - some of them might need
to be changed to 12 PM so as to give correct results.
HTH
Noticed that the time mentioned for "seconds" part is differentiated by a
decimal while it should be a colon (like it is done for the hours-minutes
part) so as to enable excel to read it as "time". Once you correct that,
you can simply deduct the down time from up time to get the difference and
set
Assuming that your values are stored in column A from cell 1 to 50, you
could use this formula in cell B1 and drag it down -
=RANK(A1,$A$1:$A$50)
HTH
Abhishek
On Wed, Sep 9, 2015 at 2:22 PM, Nasir Saikh wrote:
> Hi Experts,
>
> I need a formula to assign number value example is given below wh
Just one correction, if I may:
Countif(A1:A100,"(IRE)") would only count the cells having exact text as
"(IRE)" not those which *contain* "(IRE)". For that you would have to put
an asterisk before and after the look up text so as to do wild card search.
Here is what your formula would be:
=Counti
Is there any specific reason you want to use VBA?
In the attached sheet, I used a helper column - please see if this serves
your purpose.
Regards,
On Mon, Aug 31, 2015 at 11:25 AM, Soumyendu Paul
wrote:
> Hi,
> Is there anyone to help?
>
> On Mon, Aug 31, 2015 at 5:18 AM, Soumyendu Paul
> w
Your query is not clear...please elaborate.
On Sat, Aug 29, 2015 at 9:24 AM, My Excel wrote:
> any macro solution ?
>
>
> On Thu, Aug 27, 2015 at 10:18 PM, My Excel wrote:
>
>> Sir,
>>
>> need help on serial no generate (like attached file)
>>
>> using auto increment loop
>>
>> start from 120
Hope this helps.
Whenever you want to make any change in the formula, do it in the first
resulting value, i.e, G2 and remember to press Ctrl+Shift+Enter (not just
enter) before dragging it down.
Regards,
On Fri, Aug 28, 2015 at 12:06 PM, Shrinivas Shevde
wrote:
> Dear All
> Please find query.
Just one thing though...I forgot to freeze the ranges which might result in
incorrect values. The correct formula would be -
=LOOKUP(2,1/($A$1:$A$17=F2),$B$1:$B$17)
Regards,
On Thu, Aug 27, 2015 at 3:51 PM, Pankaj Sharma
wrote:
> Thank you Abhishek Jain
>
> On Thu, Aug 27, 201
HTH
On Thu, Aug 27, 2015 at 3:18 PM, Pankaj Sharma
wrote:
> HI Expert,,
>
> i need a formula to find last collected Amount from client.For example PFA.
>
>
>
>
>
>
> --
> 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
PFA
HTH
On Thu, Aug 13, 2015 at 1:20 PM, wrote:
> Dear Champs
>
> Please Solve My Querry In Atteched File
>
> --
> 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/discussexce
What worked for me on Outlook 2007 -
Run Outlook as Administrator (right lick on icon, run as administrator)
Go to Tools > Trust Center
Under Programmatic Access, select - Never warn me about suspicious activity
HTH, Abhishek
On Tue, Aug 4, 2015 at 2:12 PM, Soumyendu Paul
wrote:
> Hi,
>
> How
Plz see attached
On Mon, Jun 29, 2015 at 2:08 PM, Sundarvelan N wrote:
> Dear Friends,
>
> My attached excel should update the current time when the status column
> updated as Closed.
> 11
> Please Help
>
> Thanks
> N.Sundarvelan
> 9600160150
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Exc
Not clear what exactly do you want but if you put this code in the Sheet 1
module then it will give a message whenever the value is A1 is 1000.
*Private Sub Worksheet_Change(ByVal Target As Range)*
*If Sheets("Sheet1").Range("A1") = 1000 Then*
*MsgBox "A1 value is now 1000"*
*Else*
*End If*
*End S
=IF(C5<0,0,IF(C5>380,C5-B5,IF(AND(D5>0,D5<=380),C5,"NA")))
Drag down...
On Wed, May 20, 2015 at 11:22 AM, ankit sharma wrote:
> Dear Experts i want a formula that fulfill my both conditions pls solve
> this.
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =T
will send email thru your outlook..
>>
>> Cheers!!
>>
>> +
>> *I did not do this for you. God is here working through me for you.*
>>
>> On Sat, Nov 29, 2014 at 3:31 PM, Abhishek Jain
>> wrote:
>>
>>> Dear Friends,
>>>
>
Dear Friends,
I need to send files through outlook to some people along with the specific
file as attachment picked from the path mentioned in next column.
I have attached a sample file with details.
Request further help please.
Thanks & regards,
Abhishek
--
Are you =EXP(E:RT) or =NOT(EXP(E:
Not sure if your output has anything to do with sorting. Remove Duplicates
(under Data tab) will give you the same results.
Regards, Abhishek
On Sat, Jun 21, 2014 at 4:11 PM, Sourabh Salgotra
wrote:
> Dear Sir,
>
> plz solve my query related to getting the unique and
> sorting
Its a name range. See the range under "Name Manager" in the "Formulas" tab
(Excel 2007).
HTH/Abhishek
On Thu, Jun 12, 2014 at 6:29 PM, Waqar Ahmed
wrote:
> Hello everybody,
>
> I have a problem that I can't increase the list range , I can't find value
> (Range name "List") Please help.
>
> Reg
=INT((EOMONTH(A1,0)-1)/7)*7+1
Put any date of the month in question in A1 - does not matter what date.
HTH/Abhishek
On Thu, Jun 5, 2014 at 12:55 PM, 'Hanumant' via MS EXCEL AND VBA MACROS <
excel-macros@googlegroups.com> wrote:
> Hi Group,
>
> can you please let me know how can we find last s
Try this:
Private Sub test()
Dim myrng As Range
Set myrng = ActiveSheet.UsedRange
For Each cell In myrng
If IsDate(cell.Value) = True Then
cell.NumberFormat = "dd/mm/"
Else
cell.NumberFormat = "_(* #,##0.00_);_(* (#,##0.00);_(* ""-""??_);_(@_)"
End If
Next cell
End Sub
HTH/A
> Prafull Jadhav
> 9920553518
>
>
> On 27 May 2014 16:21, Abhishek Jain wrote:
>
>> Happy to help :)
>>
>>
>> On Tue, May 27, 2014 at 4:19 PM, Pravin Gunjal wrote:
>>
>>> Dear Abhishek Jee,
>>>
>>> It is really a very very helpf
Happy to help :)
On Tue, May 27, 2014 at 4:19 PM, Pravin Gunjal wrote:
> Dear Abhishek Jee,
>
> It is really a very very helpful for me.
> Thanks a ton!
>
> Regards
> Pravin Gunjal.
>
> -- Forwarded message --
> From: Abhishek Jain
> D
=IF(AND(C2="",D2>1),1,0)
Drag down.
HTH/Abhishek
On Sat, May 24, 2014 at 1:04 AM, Imran Khan wrote:
> Dear Friends,
>
> Need your help in IF formula. I have attach the file for your input.
>
> Thanks & Regards,
>
> *Imran Khan*
>
> *Lead Planner - OR/CSU*
>
> Ras Al-Khair Industrial City
>
>
After A, B, C.Y, Z and then AA, AB and so on - if you are looking for
this, you can use below after putting "A" in A1 -
=LEFT(ADDRESS(1, ROW(A1), 4, TRUE), (ROW(A1)>26)+1)
Regards, Abhishek
On Fri, May 9, 2014 at 12:21 PM, Amit Desai (MERU)
wrote:
> Dear Friends,
>
>
>
> Please help me wi
e.
>
> Thanks again for help
>
> Regards
> Amar
>
> On Thu, Apr 17, 2014 at 1:07 PM, Prafull Jadhav
> wrote:
> > Dear Abhishek Sir,
> >
> > Great.
> >
> >
> > Regards,
> > Prafull Jadhav
> > 9920553518
> >
> >
>
Dear Kapil,
Please see the attached.
This will create workbooks, paste filtered data and save them as per the
name column (Col G).
*Keep in mind the following:*
a) The new excel files will be created in the same folder* where you have
saved this file*. So, when you download this, save it in a f
I tried saving the PDF as Text and importing it in Excel, it didn't work.
Do you have a sample macro or something that I can try?
Thanks.
On Tue, Apr 1, 2014 at 11:24 PM, Ricardo(R) wrote:
> Hi Abhishek Jain,
>
> If the formatting of the PDF files is standardized, you can creat
Hi Friends,
I have a PDF file with some 11800+ pages in it (around 28 MB). Is there a
way I can convert it in Excel format using a macro or a tool?
Many thanks for help.
Regards,
Abhishek
--
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
time to contact.
> On 27-Mar-2014 11:32 PM, "Abhishek Jain" wrote:
>
>> You may please contact me via chat.
>>
>> Thanks
>>
>>
>> On Thu, Mar 27, 2014 at 10:30 PM, Prabhu Pinky wrote:
>>
>>> No abhi...since its official... Am unabl
A sample file would help understand better.
Thanks.
On Thu, Mar 27, 2014 at 8:28 PM, Tommy wrote:
> Hi,
>
> i am stuck on my project, an i am still a noob on VBA :P
>
> i have a userform with 4 textboxes and a combobox with 5 options that
> link each one to 5 sheets.
> Sheets (A,B,C,D and E)
You may please contact me via chat.
Thanks
On Thu, Mar 27, 2014 at 10:30 PM, Prabhu Pinky wrote:
> No abhi...since its official... Am unable to share...
> On 27-Mar-2014 6:00 PM, "Abhishek Jain" wrote:
>
>> Please provide more info or screenshot of the screen where
Please provide more info or screenshot of the screen where you have to
input the date generating the report.
Regards, Abhishek
On Thu, Mar 27, 2014 at 5:41 PM, Prabhu Pinky wrote:
> Yes abhi...it shld be in vba excel. Pls help
> On 26-Mar-2014 3:30 PM, "Abhishek Jain" wro
Does it have to be Excel VBA?
I am sure there are many FTP clients that support automated and scheduled
transfers (upload or download). If you want that I can look into some.
Regards,
Abhishek
On Wed, Mar 26, 2014 at 3:17 PM, Prabhu Pinky wrote:
> Hi experts,
>
> i need your suggestions on my
You sure you are pressing Ctrl+Enter after you have chose the reference
cell? I personally used this many times, it never failed me. Here's how I
do it:
1. Press F5, Go to > Special > Blanks.
2. Without losing the selection of blank cells, put *=* and select my
reference cell (preferably with an a
Abhishek,
>
> Yes, I did see the formula. Never knew it would be that straight forward
>
> Will give it a try and keep you posted. Really appreciate the help !
>
>
>
> Regards,
> Priyanka S
>
>
> On Sun, Mar 23, 2014 at 12:44 AM, Abhishek Jain wrote:
>
>&g
:26:12 AM (mm-dd-yyy hr:mm:ss)
>Closure Date = 02-12-2014 10:29:00 PM
>
> i.e it has a AM and PM instead of a 24 hour clock (eg 10:29:00 PM instead
> of 22:29:00)
>
>
> Regards,
> Priyanka S
>
>
> On Sat, Mar 22, 2014 at 7:44 PM, Abhishek Jain wrote:
>
>>
Please see attached.
HTH
On Sat, Mar 22, 2014 at 7:16 PM, Priyanka Sachdeva <
priyanka.sachdeva...@gmail.com> wrote:
> Hello All,
>
> Am looking to calculate the difference in minutes between 2 dates. (
> Inception Date and Closure Date)
>
> Eg : Inception Date = 02-12-2014 10:26:12 (mm-dd-yy
("B6:K6").PasteSpecial
>
> ThisWorkbook.Worksheets("Sheet1").Range(cpyRng).Copy
> ThisWorkbook.Worksheets(shtName).Range("A8").PasteSpecial
>
> Application.Goto ThisWorkbook.Worksheets(shtName).Range("A1"), True
> Application.CutCopyMode
You probably have the calculation in Excel set to "Manual". In Excel
Options, change it to "Automatic"
HTH/Abhishek
On Wed, Mar 19, 2014 at 4:55 PM, Kush Shama wrote:
> Dear team i am using multiple excel sheets. However i am facing a common
> problem with all files that when i press ctrl+s onl
surprise that daily Average cabs coming is 123...and that is
> wrong...
> It gives wrong Nos to Management.
>
>
>
> Regards,
> Prafull Jadhav
> 9920553518
>
>
> On 15 March 2014 20:44, ravinder negi wrote:
>
>> pls provide some example in excel wi
1 - 100 of 361 matches
Mail list logo
