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,

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

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

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,

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.

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

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

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

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

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

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

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

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

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

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

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

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

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