Hi Annen,
First welcome to the Chandoo.org
I checked your report sheet, you can try with the combination of "OFFSET" and "IF" formula.
I'll upload the complete sheet once I'll done with it.
Thanks!
Atul
Thank you so much all..
for your endless support n for everything.. you always help me, teach me..
u cant imagine how my excel knowledge has developed.. Its just because of you..
Hats off to you all.. Hats off to Chandoo.org & the team. Thanks again!
:)
Hi team,
We have a worksheet where we collate the data by using COUNTIFS formula. It's working with excel 2007 but not in 2003.
Do we have any option or any another formula which will work like COUNTIFS in excel 2003? In which we can give more criteria to count the numbers.
Thanks!
-Atul...
Hi,
I have uploaded a sample allocation sheet. please check with the following link.
https://skydrive.live.com/redir.aspx?cid=92bd629a339d0180&resid=92BD629A339D0180!107&parid=root
(Please read the info given in callout shape in "Agents" tab.)
Thank you!
Hi team,
I have a work allocation sheet, which we use to allocate the work across the team. I have used =INDEX formula to distribute the work in available agents. Now some procedure has changed.
suppose column A is for file numbers & B is for agent names. B1 has agent name "John" (which is...
How can we hide or unhide column by using formula when we are entering value in any cell.
e.g in A1 if i will enter 1 then Column F will hide and if i will enter any other number or if i will delete that 1 from A1, then Column F will unhide.
please help me in this.
Thank you!
Done!
Thanks Narayan. Using this formula, size of that excel sheet reduced from 2 MB to 50kb.
B'coz we were using =LOOKUP formula and we had a list of dates till the year of 2090.
Thanks.. Thanks a lot!
Hi,
Column A contains list of files, Column B - Names of agents, Column C - status of the file.
Now if
Agent A is working on a file so status of that file will be PENDING. same goes for COMPLETED & CUST REPLY files.
so if I want to count the files which are COMPLETED by agent A & PENDING...
Hi all,
I have one query. Please help me.
If cell A5 contains 17/11/2011 i.e 50864. I changed its format as ddd i.e Thu
Now
It looks like TEXT but the origin of that cell is a NUMBER i.e 50864.
But if I want to use "Thu" from cell A5 as a TEXT "Thu" in cell B5. Which formula can do this...
Hi Narayan,
Thanks Thanks Thanks.. IT WORKS!
But..
My BOSS is not happy with this (as usual). B'coz if some day we have only 8 people, or more than 10 people then??
so I modified that formula..
By
-ROW($5:$5),10)+1
To
-ROW($5:$5),Sheet1!$A$1)+1
and in Sheet1!$A$1 I'm entering the...
Hi all,
I am using XL 2003.
and
in column B, They are not text, they are dates only (i.e 40864 - 17/11/2011).
I am working on 17/11, and i need to update the system for next business day. if i am using +1, it will become 40865 i.e 18/11/2011 as 1 business day, but if we have official...
Hi team,
I need upcoming action by dates which we use to update the system. we don't calculate Saturday & Sunday as they are non business days.
e.g-
A B C
2| Enter Date here- | 17-11-2011 | Thu
so i get-
A B C
4| 1 business date |...
Hi Narayan..
Thanx a lot, it works but quite oppositely.
1. Actually i want name of 10 agents in Sheet1.
and
2. List of 100 files should be in Sheet2
so,
3. I want these 10 agents to be distributed amongst those 100 files.
e.g
File 1 : A
File 2 : B
.
.
File 10 : J
File 11 : A...
Hi all, Please help me in this..
If i have a list of 100 files (every file has its own diff number) in 1 tab and another list of 10 people in another tab. Now i want to distribute those 10 people in front of 100 files respectively.
After sorting 10 files to 10 people, for 11th file i again...