asked

I was just wondering if all questions get answered on this forum. I asked a question yesterday under the Excel questions, but it hasn't been answered but my other threads I asked same day were. Please don't take this the wrong way, I'm very grateful for everything you all have provided, all...

Hello and good day, The company I work for has asked me to do some Excel training at our cooperate headquarters, I was just wondering if anyone out there knows of some free material to speak/train to? I have been asked to do a beginning and intermediate/advance class. I was just looking for a...

Hi I have set up automated timeline (Gant Style) workbook for colleagues whichworks fine but they have now asked me if I can have the bar colour changeautomatically if a task is past due e.g. Green while it is in scope and redwhen it is Out of Scope. This is not something I have been asked for...

Hello all, As ever, i wondering if anyone can help with a problem i am having. In columns B & C of the attached i have some times and dates where we asked colleagues to work at short notice. In columns E & F is the time colleagues actually worked. I would like to take each instance of when...

I wasn't sure I wanted to convert my old comments/new notes to new "threaded comments" when I first started using the latter so didn't agree to convert when asked by Excel, but now I cannot find a global convert option. Is there one?

I am trying to mimic a text editor that I am using for regular expressions in VBA. The text editor I am using is Sublime. I have a bunch of phrases and the numeric values I would like to put a dollar sign in front if I do not already have one. for example: I have this: The $40.00 dollar amount...

Hi All, I have been asked by my sales director to collate information from his sales staff. Currently, they use a single shared workbook, they have their own sheet, which has a table on it. I have been asked to gather information which relates to activities of the sales people. Getting the...

I was asked to find out if this is possible, I dont think it is, I mean i can create laid out signs with adobe indesign merging my spreadsheet, but I was asked to see if it was at all Possible to convert it semi-auto or easily into a laid out sign just based off data entered. Thanks in advance...

Hi, I have an array formula, which returns a list of text codes - at the moment, these are not sorted alphabetically, however, I've now been asked to change this to return the codes in alphabetical order. Can anyone help...

I know I've asked this before, but I can't find the thread where I asked it and someone was kind enough to delete my notes from my network so here I am asking it again... What is a formula that will enable me to calculate the number of parts I can get fit on in 95". I had it set up so it would...

I need to collect forms from many departments. I want to give each department 3 weeks to a month to return their forms. I would like calculate 4th Friday from the date I asked them to fill the forms. For example, if I asked them to fill the forms on November 20th, then they should get the forms...

Have a link to my file on gdocs https://drive.google.com/file/d/0B-aNVtPlmLmvR0N6NXJWcERJUlE/view?usp=sharing You can see that I have used filters(Detailtab), Sum(9,E:E) formula (detail tab) and SumIF formula(Summary tab). I have now been asked to exclude any negative remaining when I total...

I would like to be able to select different cells, like A4, B2, C1, E5 and have them concatenated in 1 cells whereby I am asked for separator to be used, like space, or comma, or semi-colon separated So, instead of manually adding " " each time in =CONCATENATE(A4, " ", B2, " ", C1, " ", E1)...