As the title mentions, I am trying to remove all numbers at the end of a cell. Not every cell ends in a number and most of the time each cell contains numbers. These number are useless for our purposes and need to be deleted, datasets typically are received around 10k - 100k cells...
i would like to calculate how many item outstanding will be due on weekend in N/A and blank in the range.
I have a sheet called "Workflow, and another sheet called "Overview"
"Overview" is my dashboard
"Workflow" is my data"
In "Overview" (dashboard) I have a table From C13:I28
In "Workflow" I have the data I want to populate in that table.
My "Workflow" sheet has data from cells A4:J723
I am trying to learn powerpivot and wanted to know the best way to set up my data. I get an extract of student test data in a spreadsheet. It has the student name, id, grade, and the test scores for a given test. Each time they take another test, it adds a row of data. At the end of the...
I'm working on a project now that involves setting up a service desk that will be responsible for tracking and guiding individuals through a certain process. It is going to be a specialized desk that only deals with a few dozen items a year, so it doesn't make sense to use a...
I am after some sort of macro that will help me track work flow between users with some specific caveats. I'm not sure that what I want to do can be done with normal track changes so I may be in need of a macro and since my macro skills are quite basic I'm after some help. Thanks in advance...
This is my first post to this forum. Hope i get some valuable replies here. :)
I am trying to create a simple BiWeekly roster (extendable to Monthly) for my workflow support team using either VBA or worksheet functions though i am not able to proceed further than the design...