
I manage a sales company which sells sponsorship packages for events, galas, dinners etc. We have a number of sales people and my goal is to be able to create a excel sheet that is simple for company use Ideally a person could open this up and select a salesperson from the data validation list. By selecting...

So I have my check book kept in an excel file. In that same file I have my budget, what I owe and when it will be paid off. So in 4 Columns I have set up one column the name of transaction, one column for credits, one column for debits and then one column Checking balance to date. Then in another set...

Hi All Can any one help me with IF Logical formula for below query. Scenario  In a call centre, need to allocate agents/ employee for multiple accounts based on their requirement, service level %, criticality and agents availability in the pool for allocation. Account 1 Required Agents  102 Actual...

I am trying to merge two datasets, and it seems what I am trying to do should be something quite simple, but I am having a brain cramp on how to do it...so, someone, please help.... Here's what I am trying to do: For illustration purposes, let's use Columns A, B, C, X, Y, and Z. I want to write...

To whom may be able to assist. I am currently working on defining a function/automated process for generating sample intervals from a data set of intervals created from a drill hole. The data that has been captured is the 'rock type' and can stretch over 0.110's of metres. When sampling...

I am working with drug data, and the data entry conventions are ... unconventional. Multiple spacing, single spacing, hyphens, slashes ... I've got it all. My problem is that I can identify a small handful of patterns that follow the data I want to extract (drug strength), but nothing unique that...

Hi There, I need a solution that will look at the beginning numbers of a sort code and from that determine what bank that sort code belongs to. Sort code prefixes are available online so i know for example that a sort code that starts with 11 will be bank of scotland. So what i need to be able to do...

Hi All: Looking for some help on this: Here is what I put in for the formulate but I get this error in my AS INITIAL OFFER BOX: #VALUE! Here is what I have for the formula to start with so far but it is not working (once I got it working, then I was planning on addition other ranges): =IF(AT1<3499...

Hi All: Looking for some help on this: Here is what I put in for the formulate but I get this error in my AS INITIAL OFFER BOX: #VALUE! Here is what I have for the formula to start with so far but it is not working (once I got it working, then I was planning on addition other ranges): =IF(AT1<3499...

hello all.... I'm a newbie in using microsoft excel...now I got some problem that I can't solved,...may someone in this forum help me to solve it ? I have written my problem in the excel file dikirim.xls CODE A 8 E 3 1st Code Price Total 2nd Code Price Total A 50,000 83 50,000 B 100,000 A8 100...