--
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 concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, F
What code do you use? a loop? or use the "filldown" construct in VBA
Well, 60,000 is a lot of rows if you ask me
To speed up the code, you can set Application.screenupdating to false and
probably not use a loop and consider some other options,
Would you mind posting your current code, so we can
This could help with the date
=TEXT(DATE(MID(A1,8,4),MONTH(DATEVALUE(LEFT(A1,3)& " 1")),MID(A1,5,2)),"dd
mmm "), this should give you "22 Apr 2016"
But not with the time, 'cos am sure you might have times like 11:35, 12:20
and so on, so I can't hardcode a formula at the moment except if all yo
So do you need a formula to return Top 3 values as 20,17,16 and not
20,20,20?
On Sun, Apr 17, 2016 at 2:36 PM, Rajesh Agarwal wrote:
> Hello Sir
>
> formula required for top 3 value and lowest 3 value's in attached sheet.
>
> --
> *Rajesh Kumar Agarwal*
> *9811063001*
>
> --
> Are you =EXP(E:RT)
You can use this, change Sheet1 and Sheet2 to your source and destination
sheets respectively
Sub NewRearrangeMacro()
Dim wks As Worksheet, wks2 As Worksheet
Dim Lrow As Long, I As Long, j As Long, k As Long
Dim Colcount As Long
Set wks = Worksheets("Sheet1")
Set wks2 = Worksh
This non array formula should also work
=MATCH("aaa" & "~*",A1:A2,0)
On Wed, May 6, 2015 at 6:36 PM, Divaker Pandey wrote:
> say if cell a1 contains a text
> and a2 contains aaa*
> and i used match function =match("aaa*",A1:A2",0)
> it should return 2
>
> Thanks
>
> --
> Are you =EXP(E:RT)
On what sheet and on what cell do you get that error
On Thu, Dec 18, 2014 at 9:28 AM, Rakesh wrote:
>
> Dear Experts
>
> I received the following data validation error: Source evaluates to an
> error. Do you wish to continue?
>
> and when i continue nothing will changed. :(
>
> KIndly help
>
> re
You need to bring the lastrow=lastrow+1 into the IF statement, this seems
to work
Sub test()
Dim cell As Range
Dim lastrow As Long, xTitleID, I As Long
lastrow = Range("b65536").End(xlUp).Row
Dim workrng As Range
Set workrng = Application.Selection
Set workrng = Application
Hi Nitya,
I have added a FOR-LOOP and tweaked the macro a little which allows you
loop through all the table-hyperlinks in your link sheet and then performs
the import
Of course the macro can be tweaked.fine tuned but see if this works for you
Maybe test with about 5 links first before going to
Attached is the workbook with formulas that can help you achieve this
On Fri, Jun 13, 2014 at 1:06 AM, Djordje Padejski <
djordje.padej...@gmail.com> wrote:
> hello everyone,
>
> This should be easy, but I'm stuck with Excel.
>
> Have election results in 4 columns. A Candidate name, B Location
10 matches
Mail list logo
