That formula is doing the same as required !!
Regards,
MandeepBaluja
Learningzmypassion.
https://www.facebook.com/groups/825221420889809/
https://www.linkedin.com/profile/view?id=312532939
On Wednesday, July 1, 2015 at 9:22:39 AM UTC+5:30, Kumar Bhanushali wrote:
*Dear Mandeep,*
Please
If I am not wrong you want this type of data.It can easily achieved with
the help of formula even the salary slips can be printed automatically with
coding. Confirm once if this type of data is required and in case of other
scenario you can provide your much data so that I can understand the
Can someone explain me in case of error why't this code is not going
directly to next ,By running it step by step i can see in case of error it
goes to check if condition.
Sub K()
On Error Resume Next
For Each Cell In Range(a:A)
j = Application.WorksheetFunction.Search(b, Cell.Value, 1)
If Not
use this line
Set diaFolder = Application.FileDialog(msoFileDialogFilePicker)
regards,
mandeep baluja
On Wednesday, August 19, 2015 at 5:32:06 PM UTC+5:30, Chandru wrote:
Hello,
Could you please help me in attached excel file am getting error in
diaFolder.Filters.Add Excel
filedialogfolder picker means you're selecting a folder you can't apply the
property of filters on this,as you know that you want excel files only in
filter so it should be filedialogfilepicker to select the files.
Regards,
Mandeep Baluja
On Friday, August 21, 2015 at 10:25:37 AM UTC+5:30
check this
Regards,
MandeepBaluja
Learningzmypassion.
https://www.facebook.com/groups/825221420889809/
https://www.linkedin.com/profile/view?id=312532939
On Tuesday, June 30, 2015 at 12:58:29 PM UTC+5:30, amar takale wrote:
PFA
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do
Check this out !!!
Sub test()
With Sheets(Master).Range($A:$AB)
.Parent.AutoFilterMode = False
.AutoFilter Field:=3, Criteria1:=xlFilterAllDatesInPeriodJuly,
Operator:=xlFilterDynamic
End With
End Sub
Regards,
Mandeep Baluja
On Tuesday, August 4, 2015
in Col A is deleted then only the respective pictures in Col
B should be deleted .. and not all the pictures
Thanks once again.
On Mon, Aug 3, 2015 at 4:19 PM, Mandeep Baluja rocke...@gmail.com
javascript: wrote:
check this out !!
Private Sub Worksheet_Change(ByVal Target As Range
s
End If
End Sub
Regards,
Mandeep baluja
--
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
=RIGHT(A2,LEN(A2)-LOOKUP(2^15,FIND( ,A2,ROW(INDIRECT(1:LEN(A2))
check this out
Regards,
Mandeep Baluja
LearningZmyPassion
https://www.linkedin.com/profile/view?id=312532939
https://www.facebook.com/VBAEXCELSQL?ref=hl
On Thursday, August 6, 2015 at 8:53:47 AM UTC+5:30, Ashish_Bhalara
Simply put the path in excel cells
.Attachments.Add = FilePath / Cells(x, 3).Value
.Attachments.Add = FilePath / Cells(x, 4).Value
you can also use a loop there to add
Regards,
Mandeep baluja
https://www.facebook.com/groups/825221420889809/
On Friday, August 14, 2015
;) Glad to help https://www.facebook.com/groups/825221420889809/
On Thursday, August 6, 2015 at 11:55:00 AM UTC+5:30, Nasir Saikh wrote:
Thanx a lot mandeep its working.
On Wednesday, August 5, 2015 at 1:05:03 PM UTC+5:30, Nasir Saikh wrote:
Hi,
Please help me out to split numbers from
check this out
Public Sub test()
Dim dt As Variant
dt = Sheets(1).Cells(3, 4)
MsgBox dt
A = Application.Match(dt, Range(B2:EP2), 0)
MsgBox (A)
End Sub
Regards,
Mandeep Baluja
On Sunday, July 26, 2015 at 5:00:04 PM UTC+5:30, Mohamed Elamrani wrote:
Sorry for bothering you i'm new
have you got the solution by running this code ?
On Friday, July 17, 2015 at 4:39:15 PM UTC+5:30, Mandeep Baluja wrote:
paste this code in vba module
Sub Extracterdata()
Dim lr As Long
lr = ActiveSheet.Cells(Rows.Count, 1).End(xlUp).Row
For i = 2 To lr
d = Replace(Cells(i, 1).Value
check this out
Check this Out.
Regards,
Mandeep Baluja
Email :-mandeep.bal...@snapdeal.com
mandeep.bal...@gmail.com
https://in.linkedin.com/pub/mandeep-baluja/88/7bb/b77
https://www.facebook.com/groups/825221420889809/
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you
Where is the error I am not getting the same in this sheet !!, Kindly
provide the snapshot.
On Friday, July 17, 2015 at 1:40:30 PM UTC+5:30, Mahendra Verma wrote:
Getting below error:
https://lh3.googleusercontent.com/-r3AoHmozD_E/Vai4XHaYtyI/BL0/j7e-jKtapc4/s1600/error.png
--
Check this Out.
Regards,
Mandeep Baluja
Email :-mandeep.bal...@snapdeal.com
mandeep.bal...@gmail.com
https://in.linkedin.com/pub/mandeep-baluja/88/7bb/b77
https://www.facebook.com/groups/825221420889809/
On Friday, July 17, 2015 at 10:09:06 AM UTC+5:30, Mahendra Verma wrote:
Hi All,
I
/s1600/error.png
On Friday, July 17, 2015 at 2:15:40 PM UTC+5:30, Mandeep Baluja wrote:
Where is the error I am not getting the same in this sheet !!, Kindly
provide the snapshot.
On Friday, July 17, 2015 at 1:40:30 PM UTC+5:30, Mahendra Verma wrote:
Getting below error:
https://lh3
that the
file location is correct.
If you are trying to open the list of most recently used files, make sure
that the file has not been renamed, moved, or deleted.
On Friday, July 17, 2015 at 3:13:44 PM UTC+5:30, Mandeep Baluja wrote:
Where is the snapshot ? what error you're are getting have
:30, Mandeep Baluja wrote:
Try to download this file
On Friday, July 17, 2015 at 4:23:43 PM UTC+5:30, Mahendra Verma wrote:
Please find below error getting while running:
'C:\Users\Mandeep.baluja\Downloads\Daily Shipping 16th July 2015.xlsb'
could not be found. Check the spelling
Hi Dew, Check This out and let me know is this matched your criteria.
Regards,
Mandeep Baluja
On Saturday, November 7, 2015 at 1:13:30 AM UTC+5:30, Paul Schreiner wrote:
>
> I don't understand.
> You wanted to split a string into columns using "-" as the delimiter.
> Wha
Run this code
Regards,
Mandeep baluja
Sub Parse()
>
> Dim hw As Long: hw = 2
> Dim k As Long: k = 2
> Dim j As Long: j = 2
> For i = 3 To 7
> Sheets(2).Cells(1, j).Value = "Col" & j - 1
> Sheets(2).Cells(k, 1).Resize(hw, 1).Value = Sheets(1).Cells(i, 1).Val
Run this code !!! Regards, Mandeep baluja
Sub Button1_Click()
Dim i As Integer, j As Integer, k As Integer, s As String
i = 1
j = 1
Do
s = Cells(i, 4).Value
If s = "" Then Exit Do
Worksheets("DATA").Select
Cells(j, 1) = Worksheets("URL").Cells(i, 1).Va
Click on more tab available in the bottom.
Regards,
Mandeep Baluja
On Monday, November 9, 2015 at 8:39:45 AM UTC+5:30, kannan ramanathan wrote:
>
> Unable find check box to activate wild card characters in Excel
> find/replace.
>
> On Friday, November 6, 2015 at 1:17:35 AM
I want to run a VBA macro AFTER the workbook has finished opening. I don't
want to use application.ontime method to wait, I just want to run my macro
only when workbook is completely loaded.
Same as like
Do Until IE.readyState = 4
DoEventsLoop
Regards,
Mandeep baluja
--
Are you
for efficient checking of data
3. Should i use Dictionary object and store the orders no and use this
techniques.
I know how to do this but Still looking for the faster one.
Regards,
Mandeep baluja
--
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
Range("Ax1").PasteSpecial Paste:=xlPasteValues
.AutoFilterMode = False
MsgBox Join(Application.Transpose(Range("Ax1:AX" &
Range("AX65536").End(xlUp).Row)), ",")
End With
End Sub
Regards,
Mandeep Baluja
--
Are you =EXP(E:RT)
Try This -([0-9]) in find box check the wild card characters.
Regards,
Mandeep baluja
On Friday, November 6, 2015 at 6:25:46 AM UTC+5:30, kannan ramanathan wrote:
>
>
>
> In MS Word, I can
> search for any letter using ^$
> search for any number using ^#
> I
Hi Paul,
Kindly post the answer for this Query So That we can learn that trick too.
On Thursday, November 5, 2015 at 10:33:47 PM UTC+5:30, Abhi wrote:
>
> Paul,
>
> You are a real genius.
>
> For around 42000 rows and 15000 look up values,* it took less than a
> minute.*
>
> Can't be better
Kindly Provide the Full code for better understanding as this code doesn't
seems to work as per your requirement . Difficult to figure Out where the
Num Sell is using as input.
Regards,
Mandeep
--
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)
Name
End If
Next
End If
End Sub
Regards,
Mandeep baluja
https://www.facebook.com/groups/825221420889809/
--
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.facebo
Hi Praveen,
Welcome,I am sorry but Please elaborate your query Modify in what sense and
for all sheets means you have the same code in all sheets what kind of
modification you're looking for whether it is automated or it is manual.
Regards,
Mandeep Baluja
On Tuesday, October 20, 2015 at 4
at 2:37:17 PM UTC+5:30, pappu wrote:
Than of ur reply Bro, I am using excel 2010. In my company mail, ur
attachment has not open. It's showing 'the file is corrupt and cannot
opened'.
--
From: Mandeep Baluja javascript:
Sent: 10-07-2015 01:44 PM
To: excel
Regards, Mandeep Baluja
Run this code output will receive in sheet2 and the criteria to get the
result is pasted in sheet3.
Sub Createdata()
Lc = Sheets(Sheet3).Cells(Rows.Count, 1).End(xlUp).Row
Sheets(Sheet2).Cells.ClearContents
a = 5
b = 5
For a1 = 2 To Lc
v = Split(Sheets(Sheet3
use this udf
Function allthebest(Rng As Range)
Set c = Rng
k = -1 * c.Value
k1 = c.Offset(-c + 1, -5).Address
Set j = Range(k1, c.Offset(0, -5))
allthebest = Application.WorksheetFunction.Average(j)
End Function
Check this Out.
Regards,
Mandeep Baluja
Email :-mandeep.bal
Code Changed !! Try this Check this Out.
Regards,
Mandeep Baluja
Email :-mandeep.bal...@snapdeal.com
mandeep.bal...@gmail.com
https://in.linkedin.com/pub/mandeep-baluja/88/7bb/b77
https://www.facebook.com/groups/825221420889809/
Sub Createdata()
Lc = Sheets(Sheet3).Cells(Rows.Count, 1
Go to tools reference and uncheck the reference file starts with missing
then your code will work fine :D
Check this Out.
Regards,
Mandeep Baluja
Email :-mandeep.bal...@snapdeal.com
mandeep.bal...@gmail.com
https://in.linkedin.com/pub/mandeep-baluja/88/7bb/b77
https://www.facebook.com
Check this attachment :!
Check this Out.
Regards,
Mandeep Baluja
Email :-mandeep.bal...@snapdeal.com
mandeep.bal...@gmail.com
https://in.linkedin.com/pub/mandeep-baluja/88/7bb/b77
https://www.facebook.com/groups/825221420889809/
On Friday, July 10, 2015 at 7:46:59 AM UTC+5:30, pappu wrote
change f5 the cell reference as per your need
=RIGHT(F5,LEN(F5)-LOOKUP(99,FIND("/",F5,ROW(INDIRECT("1:"(F5))
press ctrl +shift+enter
Regards,
Mandeep baluja
https://www.facebook.com/groups/825221420889809/
On Wednesday, September 23, 2015 at 12:04:06 PM UT
Dear Paul,
Could you please let me know the explanation of this code after for loop as
I am unable to understand the same ??
Sub CombineRows()
'Update 20130829
Dim WorkRng As Range
Dim Dic As Variant
Dim arr As Variant
On Error Resume Next
Set WorkRng = Application.Selection
Set WorkRng =
>
> Check this attachment !! regards, Mandeep
>
--
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
>
> Please follow the group rules, Post question related to Excel , Try this.
>
> http://www.labnol.org/internet/transfer-gmail/28088/
Regards,
Mandeep baluja
--
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 offic
>
> Here is attached two files , install the addin windatepicker.xlam first
>> and then run that Att file, Double click on date which u want to select.
>
>
Regards,
Mandeep baluja
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,
Run this code and let me know
Regards,
Mandeep baluja
Private Sub Worksheet_Change(ByVal Target As Range)
Dim Rownum As Long:
Dim colnum As Long:
Dim Temp As Long: Temp = 4
Dim lastentry As Long
With ActiveSheet
For colnum = 2 To 6
If colnum = 3 Or colnum = 6
; your requirement.
Regards,
Mandeep baluja
>
--
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 threa
>
> Find the attachment and let me know !!
>
Regards,
Mandeep baluja
--
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) Us
Sorry , I am bit confused are you willing to run a query of SQL from
Excel, Thant's needs a connection, Or you're trying to work in Excel as
same as you do in SQL by Getting Data as per your requirement from Sheet1
to Output sheet with the help of Macros/VBA Codes.
Regards,
Mandeep baluja
for negative
=IF(AND(J8:O8>0),"True","False")
Regards,
Mandeep baluja
--
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 c
Check this updated Attachment !!!
Regards,
Mandeep baluja
https://www.facebook.com/groups/825221420889809/
--
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
Check this out !!
Mandeep baluja
On Wednesday, December 9, 2015 at 3:31:45 PM UTC+5:30, Sadiq wrote:
>
> Hello Team ,
>
>
>
> I have a excel sheet where have Team Name in “A” column and in “B” column
> we have count. I need Team name details in another sheet with
Go to tools reference enable microsoft internet controls, microsoft html
object librarary. I did the coding to process data from excel to this
website but unable to fill the datepicker control working on Jquery to do
the same that will soon post the same.
Regards,
Mandeep baluja
Check this out and let me know !!!
Two formulas to be used !!
Regards,
Mandeep baluja
--
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
Check this out !!!
Regards,
Mandeep baluja
On Wednesday, December 9, 2015 at 5:22:27 PM UTC+5:30, Sadiq wrote:
>
> I did not required the count of name .
>
> I need that names in cells of given count.
>
> e.g -
>
> Name- Sadiq
> Count 20
>
> I need
Hi,
Give us a clear explanation to what to achieve by giving some output !!
Regards,
Mandeep baluja
--
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
Thanks Bro,I tried my best took some help from my friend lokesh for
Datepicker control. By google chrome select the tag element and see the
name by right click and go to inspect element and check the name !! You
Can't name them but you can assign it to objects and do the manipulation on
Hi Paul, Thanks for you Good suggestions will apply the same in future, the
thing which i was looking to remove the InStr statements which is checking
multiply as you instructed combining the values first and adding it in
dictionary object to remove duplicacy(Given Below) will not combine the
Hi,
Kindly elaborate your query !!
Regards,
Mandeep Baluja
--
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
07ad6d#gid=0;
ie.Visible = True
Application.SendKeys "%+FD{Enter}", True
End Sub
Regards,
Mandeep baluja
--
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/discus
Check this out !!!
Regards,
Mandeep baluja
--
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
Let me know !!
Sub CreateSheetsDemo()
Dim wb As Workbook
Dim wbtemp As Workbook
Dim Workrng As Range
Dim uniquename As Variant
Dim Dic As Object
Dim lr As Long: lr = Sheets("Order").Cells(Rows.Count, 4).End(xlUp).Row
mypath = ThisWorkbook.Path & "\"
:(.
Once the file is downloaded rest of work is easy
Regards,
Mandeep baluja
--
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
Glad to help !!!
Regards,
Mandeep baluja
>
--
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 thr
Did you run the code in input file ? Have you tried debugging of code step
by step ? Why paste:=xlpasteall is deleted ? I have not received this error
while running this code something u are doing wrong unintentionally.
Regards,
Mandeep
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel?
>
> Try This code !!
>
Sub CreateSheetsDemo()
Dim wb As Workbook
Dim wbtemp As Workbook
Dim Workrng As Range
Dim uniquename As Variant
Dim Dic As Object
Dim lr As Long: lr = Sheets("Order").Cells(Rows.Count, 4).End(xlUp).Row
mypath = ThisWorkbook.Path & "\"
>
> Check this out,Easily achieved with formula
> {=IFERROR(INDEX(Raw!$D$2:$H$85,MATCH('WAVE 1'!$A4&'WAVE 1'!B$2&'WAVE
> 1'!$A$2,Raw!$A$2:$A$85!$B$2:$B$85!$C$2:$C$85,0),MATCH(B$3,Raw!$D$1:$H$1,0)),0)}
>
Regards,
Mandeep baluja
--
Are you =EXP(E:RT) or =
>
> Hey check this out !!
>>
>
Regards,
Mandeep baluja
--
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,
eir score 30& 10 = 40 gets divided by 4. so
the score in k4 is 20,l4=30,m4=0,n4=0,o4 =25 & p4=25,*so that final score
in i4 is 100. if any parameter goes "No"*, then its number get deducted
from total score.
8) Also, in k11, why the score is 20. It should be 10 only accordin
Check this out !!
REgards,
Mandeep baluja
--
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
,
Mandeep baluja
--
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
Check this out !! and let me know
Sub CreateSheetsDemo()
Dim wb As Workbook
Dim wbtemp As Workbook
Dim Workrng As Range
Dim uniquename As Variant
Dim Dic As Object
Dim lr As Long: lr = Sheets("Order").Cells(Rows.Count, 4).End(xlUp).Row
mypath = ThisWorkbook.Path
Run this code !! Mandeep baluja
Sub SplitPara()
Dim lr As Long: lr = ActiveSheet.Cells(Rows.Count, 1).End(xlUp).Row
Dim j As Long: j = 0
For Nrow = 2 To lr
arr = Split(Trim(Range("A" & Nrow).Value), vbLf)
ReDim arr1(LBound(arr) To UBound(arr))
For lb = LBound(arr)
to retrieve and on what criteria as
you sales table have duplicates.
Regards,
Mandeep baluja
--
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
Check this attachment !! userid for admin is : admin and password is 123
same as for Guest.
Regards,
Mandeep baluja
https://www.facebook.com/groups/825221420889809/
--
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
Check this out is this you're looking for !! Regards, Mandeep baluja
Sub GetDetails_of_Sheet()
Dim ws As Worksheet
Dim i As Long: i = 2
On Error Resume Next
Application.ScreenUpdating = False
Application.DisplayAlerts = False
For Each sht In ActiveWorkbook.Sheets
If sht.Name = "
g and date format to
mm/dd/ you will get the correct results.
Now, As I checked the Question You Can solve it by Simply using Correct
formats of Date by changing Dates Format.
Note:: Don't forget to remove the Spaces around your Text
Thanks,
Mandeep baluja
--
Are you =EXP(E:RT) or =NO
Check this attachment and let me know !!
Regards mandeep baluja
Sub Grouping_Highlight()
Application.ScreenUpdating = False
Dim d As Object
Dim i As Long
Set d = CreateObject("Scripting.dictionary")
Set oneRange = ActiveSheet.UsedRange
Set aCell = Range("B1")
oneRa
t formula in b1 = Text(A1,0)
Put formula in C1 = A1=B1
You will get a false this means cell in A1 is integer which is not equal to
cell value which is text in Cell B2.
Regards,
Mandeep baluja
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:
wish to remove that too ???
>
Regards,
Mandeep baluja
>
>
--
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 th
ation.Transpose(Arr1)
d = Dic_obj.Count
'Retrieving Items of particular Key
For i = 2 To Dic_obj.Count
Sheet2.Cells(i, 2).Value = Dic_obj.Item(Sheet2.Cells(i,
1).Value)
Next
End With
End Sub
Regards,
Mandeep baluja
--
Are you =EXP(E:RT) or =NOT(EXP(E:R
Debug.Print Cells(Data.Row, "A").Address
If Sheets("sheet1").Cells(Data.Row, "A") <> "" Then
Cells(Data.Row, "A") = Cells(Data.Row, "A") - 1
End If
Next
End Sub
Regards,
Mandeep baluja
https://www.facebook.com/groups/8252
Hi Shrini ,
Change that line with this line and try.
*If CStr(Sheets("Production").Cells(Data.Row, "Z").Value) & "X" <> "X" Then*
Regards,
Mandeep baluja
On Wednesday, November 18, 2015 at 6:19:26 PM UTC+5:30, Paul Sc
Hi paul,
But while correcting it this is giving error. please find the attached
file. it works on small amount of data easily but while using the data in
sheet it gives error. I admit by mistake i put demo in the code.
Regards,
Mandeep baluja
On Wednesday, November 18, 2015 at 6:07:13
Try this and let me know !!
Sub Dates_Test()
Dim i As Long
For i = 1 To Cells(Rows.Count, 1).End(xlUp).Row
Cells(i, 3).Value = Cells(i, 1).Value
Cells(i, 3).Value = Format(Cells(i, 1).Value, "mmdd")
Cells(i, 3).NumberFormat = "General"
Next
End Sub
Regards,
Mandeep ba
Any update >??
On Thursday, November 19, 2015 at 1:34:51 PM UTC+5:30, Mandeep Baluja wrote:
>
> Hi paul,
>
> But while correcting it this is giving error. please find the attached
> file. it works on small amount of data easily but while using the data in
> sheet it
CTRL+D
CTRL + R
to copy the formula below and to the right.
Regards,
Mandeep baluja
On Monday, November 23, 2015 at 9:32:12 AM UTC+5:30, GENIUS wrote:
>
> HI EVERYONE
> can we use any keyboard key for double clicking the plus sign for copying
> the formula below
What please see your dates which i copied from your sheet how 2010 year
will be 2015 ? ?
DATE1 15-10-2010 15-12-2010 10/14/15 10/16/15 10/18/15 10/22/15 10/24/15
10/26/15 10/27/15 10/29/15 15-01-2011 15-04-2011 15-06-2011 15-07-2011
15-09-2010 15-10-2010 10/14/15 10/15/15 10/17/15 10/20/15
on used range parameter same as +plus sign work which is autofill
Regards,
Mandeep baluja
--
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
But paul Excel allows you to enter up to 32,767 characters in each cell.
its just 411 then why the error is showing.
--
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 @
Hey Kat,
I am sorry but i didn't get the logic of this code which is totally
different from your above query,Things which i understand its just checking
whether file_name following the criteria or not,
if 9th letter of the file name is equal to R then do something else show
error in all
>
> PFA !! Mandeep baluja
--
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
>
> Can you please provide the output format you're looking for, This will
> help us for better understanding.
>
Regards,
Mandeep baluja
--
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 fo
n interval
Confirm this first !!
Regards,
Mandeep baluja
--
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 ti
Put this in f8 =MAX($C$8:$C$11)
put this in g8 =MIN($C$8:$C$11)
Ticket closed -
--
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
ot;Sheet3").Cells(Rows.Count, 11).End(xlUp).Row
For i = 1 To l1
ReDim Preserve varout(1 To counter)
varout(i) = ws.Cells(i, 1).Value
counter = counter + 1
Next
' MsgBox Join(varout, ",")
For j = 1 To l2
ReDim Preserve varout(1 To counter + 1)
varout(counter) = ws.Cel
>
> Didn't get what is ref.name ??? Didn't find it anywhere in your data,Will
> it be possible if you share the output required format.
>
Regards,
Mandeep baluja
--
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 F
Does output sheet created for each Pref value given below ?? if yes are
these sheets created in same workbook with Pref name if not, means you need
only one sheet for pref 10001 ?
Regards,
Mandeep Baluja
Pref 1001 1002 1005 1007 1009 1005 25000 151233
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT
>
> PFA !! Ticket closed
>
Regards,
Mandeep baluja
--
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 tit
Hey Devendra,
Asked for output format? your query is not understandable. data shuffled
all the data ??,
Show me the output you require for this data given below :-
Col 1Col 2
A10,8year,5 year,15
B15,20year,17
D30,50 year,12
--
Are you
Multiply date with 1
On Thursday, January 14, 2016 at 5:54:19 PM UTC+5:30, neeraj chauhan wrote:
>
> Dear sir,
>
>
>
> Thanks sir !!
>
> Kindly share the formula.
>
>
>
> *From:* excel-...@googlegroups.com [mailto:
> excel-...@googlegroups.com
PFA !!
Regards,
Mandeep baluja
--
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
301 - 400 of 454 matches
Mail list logo