Hi,
I have a statistical analysis report and would like to hire someone to fix the entire reports on the excel. I have got a serious issue on the correlation analysis. Basically, I dont know how to do this.
had an assignments on statistics that i had a raw data related to smoking survey , the...
Hi,
I was developing a macro to search the user given text on any cell and if found copy paste entire row from Column A till the end of that particular row to a new sheet on the macro workbook. I think its working except on the merged fields.
Can any experts help me to sort it out.
Macro...
Dear Ninjas,
How can i make the following code to a single string!
Sub lastRow()
Dim lastRow As Long
lastRow = Range("B" & Rows.Count).End(xlUp).Row
Range("C41").AutoFill Destination:=Range("C41:C" & lastRow)
Range("D41").AutoFill Destination:=Range("D41:D" & lastRow)...
Hi,
can anyone help me to fix the following formula. I have attached a sample for better understanding.
I want to see the following results on the attached sheet
Grace Period (90 days after renewal date)
Valid (<=Renewal Date)
Expired (>Grace Date)
Can anyone build the logic.
Hi,
Based on the dates provided on the cells "I1" and "J1" (linked "S3" where the user will input on going month date) the macro will auto filter "B5:Y" on the following:
1. First filtering will be done on Contract Signed ("F5") and copy the filtered data to the table then macro will delete...
Dear Experts!
Can you please check the formula given below. I am not getting results.
=COUNTIFS('NEW REGISTER'!$I$6:$I$5001,"<=" &"31/1/2014",'NEW REGISTER'!$I$6:$I$5001,">="& "31/12/2018")
Dears,
Following formula is giving "Value" error. Can you please fix my issue.
=SUMPRODUCT(--(X$3:BL$3=S1),A$4:A$49,AH$4:AH$49)
I have attached a sample file for your review.
Thanks in Advance!
Can anyone help me to create a formula to do auto serial numbering on a table based on the item description? If the item is duplicated, then the particular serial number should be increased. in the following example look into "item 1"; where you can see the SN 1,2,3,4.
SN Item Description
1 1...
With the following XML code I can see only one group. Can anyone advise me how to add a New Group to the ribbon bar?
<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui">
<ribbon>
<tabs>
<tab
id="Tab1"
label="QUICK FIX">
<group
id="Group1"
label="Time Saving Tools">
<menu...