User Profile
Jane_at_Stamma
Copper Contributor
Joined Jul 15, 2021
User Widgets
Recent Discussions
How can I extrapolate a table into a list
Hi I've spend a fruitless day trying to do what I know is a simple task. And utterly failed. I've a schedule of workshops over 4 days taking place in up to 6 different rooms. When we work out which workshop is going where it can be dumped into a timetable. So far so glorious. Now I just want to be able to squirt out the workshop numbers for each day, in day/time order, with the room number next to it. What could be simpler. Damned if I know. Would it be easier to use Word to get this list?Solved1.7KViews0likes4CommentsRe: Use colour to enter a logical value
thank you Riny_van_Eekelen for your time! I updated the pivot table - lord I find them really hard - and have noticed that now I have a number of calls labelled as repeat=yes, (3) in both June and July, which aren't coloured pink, nor can I find when they are repeated. all the other months/years look fine2.6KViews0likes3Comments- 2.6KViews0likes5Comments
Re: Use colour to enter a logical value
Riny_van_Eekelen Hi, I've just pulled in data from the last month and I realise that some where there are blank cells it is pulling that in as a repeat call. At least I think that is what is happening. The data isn't being pulled through to the pivot table at despite being refreshed.2.6KViews0likes7CommentsUse colour to enter a logical value
Hi. I need to put a value into a cell to show we have a repeat caller. I've used the conditional formatting for duplicate numbers (the last part only, so not an exact science), so these have been coloured Light red fill with Dark Red Text. I want now to create a column which contains yes or no, depending on whether this is a repeat call, so a simple True/False would do.Solved3.1KViews0likes12Comments
Recent Blog Articles
No content to show