guide

  1. C

    Formula Guide

    Hello All, There is a formula guide that pops up under a cell when writing formulas. It is most helpful to ensure all requirements are met. I have only seen it in excel for PCs. I am trying to enable it in excel on my MAC, but I don't know what it is called. Any help would be most appreciated,
  2. D

    Set Due Date/Time using DateAdd exclude weekend and holiday

    Hello, Need help, i use DateAdd function in my Query, DateAdd("d",numberofdays,StartDate), however i need to exclude the weekend and holidays. Can you guide me on how i can do that. Thanks Regards, Den
  3. L

    Excel Transpose (T) From Column to Row specific position.

    I would like to ask any possible Transpose shortcut on my recent project, which wish someone here guide how to Transpose as attached image. Appreciate someone help. thanks
  4. Naveed Ul Haq

    Add-Ins

    Hello Everyone, I am interested in learning about Add-Ins, specifically how to make them. Any helpful resource you know about??? Any links to guide, videos etc. Regards,
  5. K

    Transposing with dynamic row records Help needed VBA

    Hi gurus. I am trying to convert a data table( see attach "input" file) into single column ( see "output" file) appreciat you can guide me on where to start ? Thank you.
  6. T

    Calculate Hours between two dates without weekend

    Hi fellows. I have two dates like following 2019-03-07 21:00 2019-03-18 11:00 I would like to know how many hours between these two dates omitting Saturday and Sunday Kindly guide me for the formula to get results Kind Regards
  7. V

    How to open VBA forms from VBA Application (exe file)

    Dear All, Please guide me about how do i open vba forms and coding pages from one my vba application file type.. Pls guide someone..
  8. sumsaam

    Best VBA Book

    Hi friends i want to learn vba programming for excel. can anyone guide me the best vba book. thank you.
  9. A

    Report page break

    Can we set page break in access if yes kindly guide about it Thanks in advance ?
  10. M

    Formatting a column based on today's date

    I have a spreadsheet I'm using as an order guide for my job. Once my order guide is filled out, I have to manually type the order in a program to send to our warehouse for picking. Here is an example of how my order guide is laid out: <tbody> A B C ACF ACG ACH ACI ACJ ACK ACL ACM ACN 1...
  11. T

    Condition Check for the Current Cell

    Hello Friends, Cell A1=1, A2=1, A3=A1*A2 When I change A1 Value and if it gives A3>previous value I would like to store the A1=A4 kindly guide me Regards
  12. B

    Facing issue while running INSERT query

    Hi, I am using database copied from below url. https://www.w3schools.com/sql/sql_insert.asp I am using insert query, however when I run this query CustomerID remains blank. But the website mentions that it should get auto-populated. Can anyone please guide me about this. insert into...
  13. L

    Comparing values from 2 different Workbook Worksheets - 2nd Worksheet will not return Value

    Basically Opening the 1st Workbook(worksheet) and storing the value of 2 different cells then (this works) Opening the 2nd Workbook(worksheet) and storing the value of 2 different cells (this does not work) I can see that the correct workbooks(worksheet) are being opened BUT I cant seem to...
  14. A

    "AND" query

    Dear friends, I have a formula, working fine but I don't know how to extend the query...!!! The query is in cell N8 : If L8 = "Buy" (M8-P8)+M8 Else M8-(ABS(P8-M8)) This works fine. But I want to extend it with the addition to the first formula : If K8 = "", N8 = "" Please guide & help...
  15. D

    Need a help how to analyze and enter a complex formulas

    hi my name is Deepak i need a help how to do a complex formulas i have done all single formulas but i don't know how to do a complex formulas when to use and how to use please guide me. Thank you
  16. D

    Quick formula need!

    I have some skus, and I need a formula that will cut off part of it. Here are some examples: KIDZ-1960-1-SPCP GUIDE-G6713 EC4R(1a)-ELR-15651-BK Those are examples of different kinds. I need JUST the letters before the first hyphen, but I also need it to cut off if there's a parenthesis. So for...
  17. F

    If Condition

    Hi, just curious , how can I use if condition in the following situation : A1 = 5 B1 = 5 If A1=B1 then C1 = OK BUT I do not want to use formula in C1, I want to use formula in any other cell and want result in C1. How can I do ? Please guide . Thanks
  18. P

    Turning any number caracters Red

    Hey. Heres the deal. We receive these 700 page pdf guides that we need to extract into excel. What I am looking for is a way in excel to change every single number caracter RED without changing the actual number or , I want to change the format of each cell to be GREEN IF it contains a...

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