exce formula

  1. N

    Exported excel sheet data validation

    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...
  2. N

    Cell validations

    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.
  3. K

    Combine 2 formulas into one

    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...
  4. P

    Understanding VBA Macro

    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...
  5. A

    How to calculate cell values in excel based on the criteria

    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...
  6. K

    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 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...
  7. C

    Check if value in List 2 exist in Range 1 or not

    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...
  8. K

    How to Get Period-wise Stock

    @ 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)
  9. K

    Get Stock Balance After check " CATAGORY NAME " WITH "PRODUCT LIST" and show result

    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
  10. C

    Filter for older versions

    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!
  11. I

    Dependent dropdown in excel with values from another tab

    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...
  12. K

    How Get Question Reference

    (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...
  13. T

    Compare Cell A to see if value is either in one column or both

    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...
  14. P

    Vlookup and transpose the attributes as headers

    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...
  15. E

    Round last integer to the nearest value from a list

    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...
  16. K

    How to show selected menu in slicer to other cell ??? (Like a Refrence Indication)

    @ 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
  17. K

    How get Sum value via "HSN Code" vise ?????? (without pivotable / without filter/ without VBA)

    # 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)
  18. R

    Salary Distribution and 3 percent increment every year on hire date

    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...
  19. R

    How to copy cell value from one table to another table with Criteria

    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...
  20. R

    ISNUMBER FORMULA

    Dear Guys I have the following formula =IF(ISNUMBER(N7),"Credit Doc Reviewed","Not applicable") I would like to add the following to the above formula :- if n7=number then s7= "Credit Doc Reviewed" else if blank "not applicable" if O7= number then S7="Sanction letter Sent to LOB"...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top