gal

Good afternoon, I found the following functions to get information from the GAL, the first one (GetAliasFromName) collects the Alias based on the user name and it works smoothly, however, the second one (GetNameFromAlias) is intended to do the opposite and Im getting the same incorrect result...

In one of the cells in my worksheet, I have entered the following formula: =CONCATENATE("Qtr 1 Average: $"&SUM(B2+C2+D2)/3)&" ("&SUM(B3+C3+D3)&" gal used)" which gives me the following: Qtr 1 Average: $53.9066666666667 (64.39 gal used) I'd like the number that follows the word "average" to...

I am looking for a direction to automate this manual intense process. I have different counts to do each week example Week 5 53 Week 6 30 Week 7 51 Week 8 55 Week 9 51 Week 10 60 I am looking to take the week total and split it into 5 workdays to complete The problem is each week is different...

I have a problem I cannot work out. I need to show billing numbers according to the following table but cannot get my IF statement right. It is beyond my comprehension and I need help! Thanks! <colgroup><col><col span="2"><col span="2"></colgroup><tbody> base rate 14.61 0-2ccf 3.76...

Hello there everybody. In Excel I would like to find contact names stored in GAL to enter data under a column named "Contacts". So, lets say I'm at the "Contacts" column and I click on a cell under it, I would like for the GAL window to pop up so that I can search for a contact, select the...

I have a list of names in excel. The Outlook alias is in one column and is what I am passing to create an outlook message. What I really need is to also look up the managers name of the outlook contact. This could be done with two separate macros if needed. I was hoping that I could pass in the...