exce formula

Hi, Please I need excel to repeat text in a cell 2x That is REPT(text, 2) IF the text is not repeated, but if it is already repeated 2x, it should not and leave it that way. =IF(B2=REPT(B2,1), B2=REPT(B2,2), B2=B2) It gives me False, then 0 gives me true. Excel formula or VBA would be...

Hi Team, I am working on a request where an excel sheet has few columns with columns format like(SSN , ZIP code and YYYYMMDD format) data. Now on the same sheet there is a button. If I click on that button, then all the sheet data will be exported to a new excel sheet and that will be saved into...

I have a written a script in VBA. while checking a CheckBox, it should check if respective cells(D26,D27,D28) have numerical value or not. The below code is working if I am writing values under/or 10000. If I am giving some larger values, its not working. Please help me how to achieve this.

I have a formula that works but need to put a twist on it to look at another column / Sheet. {=IF(ROWS(E$5:E5)<=$B$8,INDEX(INDIRECT(E$4),SMALL(IF(Date_Received=$A$8,ROW(Date_Received)-ROW(AuditLog!$B$2)+1),ROWS(E$5:E5))),"")} This is working. I need to add this to it...

Hi, I have a macro created by one of my former colleagues. It a bit complex macro with multiple steps which includes application of mutiple formula. He is no longer working for us, and we have decided to move to power automate with Office scripts. I have been decoding each step and converting...

I am trying to build the logic in Excel where the value gets updated based on the Load criteria. I have attached an example where the row should update once the total of the cells in row 2 is in multiples of the load value. The logic should then take the difference i.e Total - Load and then...

I was make Print to PDF With Duplex page , its Work , But How to set (Top, bottom, Left, Right Margin) in this VBA code.... i was Create MODULE and put this VBA code , So Amazing Trick to ,make Print TO PDF with Duplex (Both-side),,,,, Kindly Provide set VBA code For both page Margin...

Thought it was an easy one but it wasn't ^^", I'm trying to see if value in in Range 1 exist in List 2 or not. If yes return 1 if no return 0 in array (example of expected result in column C). I try COUNTIF, IF, SUMIF, SUMPRODUCT but didn't get the result I want, any suggestion please? Thank...

@ How to Get Period-wise Stock N3 =SUMIFS(E:E,C:C,L3,D:D,M3) ( IN) O3 =SUMIFS(J:J,H:H,L3,I:I,M3) (OUT)

how to Get Stock Balance After check " CATAGORY NAME " WITH "PRODUCT LIST" and show result - I was try but i was failed matching Product list with Category Kindly Need formula this Query K3 =SUMIF(A:A,I3,C:C) L3 =SUMIF(E:E,I3,G:G) M3 =K3-L3

Hi, how do I translate this formula for an older version? I'm thinking offset but can't find the way to make it work. Thank you!

Hello, I have an excel sheet of products. I've created a dropdown but what I want now is whenever from the dropdown I select a product, it's price is fetched from another tab and also expenses of that from another sheet. I'm attaching a screenshot which will make it easier to understand...

(1) How to get reference Sheet 1 to Sheet 2 (2) We Need four Option Reference According Match Question on Sheet 1 *Kindly make this formula for "sheet2" Condition 1 :- i will change Serial Number After Change Question in "sheet 2" (match Serial no. and question to "sheet1") Condition...

I am to looking at value in A column and see if it's in only column B, but not in column C. If it's true (in column B only) then I want to enter cell A value in column D otherwise blank A B...

Hi All , I am facing an issue with an excel automation . I have the following excel Sheet … idx Group Family Quantity Audit comments y/n 1 Apple Red 100 2 Apple Green 20 3 Orange Mandarin 100 4 Orange Tangerine 88 5 Pineapple Brecheche 60 6 Pineapple Queen 70 7 Apple...

Hi, my boss wants me to create a formula for the prices of his products. He wanted all prices below 99.99 to be rounded up to xx.97 and the values from 99.99 and greater to be rounded up to xx.00 and I have managed to put together a round formula like this...

@ How to show selected menu in slicer to other cell ??? (Like a Reference Indication) in pivot table ???? I have Try selection in slicer information reference to other cell , Above image like this yellow Highlight cell this reference

# How get Sum value via "HSN Code" vise ?????? Advance Condition : "if 100 or More Entries in sheets how it possible to solve query via Formula this Concepts " (without pivotable / without filter/ without VBA)

I have data set consisting information like Salary, Hire Date, Termination Date, Status of employee. We want to distribute that salary in 12 months and also want to factor 3% increment every year from their joining date. Also want to factor in condition that if any employee joins in current...

Hi, I am new to VBA, please help me with the below request. I would like to Copy the data from table1 (sheet1) to table2 (sheet2) based on the criteria "Yes" automatically or some action. The table 1 is located in Sheet 1 and table2 is located in Sheet2. For clear understanding I have...