Search results

Problem solved after a lot of trying...

I do not know any other way to explain.

Is this explanation better? A B C D E F G H I J Title Next due Forecast Received from Originator Sent to Checker Checker return Returned to Originator With Originator With Checker With Us Test 1 19.04.2024 15.04.2024 X here if D is not empty and E is empty Test 2 30.01.2024...

Sorry, I do not understand what youre asking.

That looks correct.

An explanation to wath I am thinking. Comments Cross in With Us shall be when it is received from originator but column E,F and G is empty. Or like in the nect row. Cross in with us if column F is not empty and G is impty. Cross in with originator if Column D is empty Crossin with...

I have a table like this: Title Next due Forecast Received from Originator Sent to Checker Checker return Returned to Originator With Originator With Checker With Us Comments Test 1 19.04.2024 15.04.2024 X Received by us but not expedited Test 2 30.01.2024 23.02.2024...

Super. That worked. Than ks.

I have a spreadsheet with a status column and a date column. Status can be 1 = Finished and 2 = Outstanding I'm looking for a way to highlight the row where the status is 2 and the date is overdue. It looks like this: Id Name Action Status Due Date 1 Peter 1 10.03.2024 2 Alex 2...

Solved. I found the solution myself.

Yes I seee that now. But I cant find a way to change it to start on zero.

I have a spreadsheet where I like to put in astacked bar. The chart shows Completed and Outstanding cases. I want it to show the number of completed to the left and Outstanding to the right. In that way the bar will grow to the right as the tasks will be complete. I have attached a sample...

This was really cool. Hov can I make this with the coding on a seperate Tab?

Thanks for the quick help. It works perfect.

I have a column A with four different status descriptions. I want to convert this in to a number for each code. Accepted = 1 Accepted with comments = 2 Not accepted, revise and resubmit = 3 For information only =4 I have tried this formula: '=IF(A2="Accepted";"1";IF(A2="Accepted with...

I have a spreadsheet with documents showing dates for planed issue, actually issued, rejected or approved. I want to create a chart showing the exact number of documents in each status on a timeline. I have attached an example file with a picture of a chart looking like the one I'm trying to...

Thanks. Worked perfect.

Can anyone help me create a conditional formatting based on two different conditions? I have a spreadsheet Where I have one column for Status and one for the date of reply. I have made some conditional formatting's that colors the row red if Status is 2, and green if status is 1 or 4. What I'm...

I have a report from an external system showing a long list of documents. List shows document numbers, title revision and so on. Looking like this Document Number Revision Issue reason Status Title 10003276804 1 Issued for CR 2 GENERAL ARRANGEMENT 10003276804 2 Re-issued CR 2 GENERAL...

Thanks!!!

I have uploaded the example file.

I have a spreadsheet with two different date columns. One for started date and one for closed date. The tate format is dd.mm.yyyy In order to report how many cases that was opened and closed each month I need a way to do this. I was planning to add a new columnd next to the date columns and...

The information is taken from a database that have no Excel eksport function. Så I mark it on screen and paste into Excel and excel cjanges it to date format. To put ' in front is a lot of work.

I'm putting in information from into Excel. All lines are numbered in chapeter numbers that is important to keep. 14.1.0 14.1.1 14.1.2 14.2.0 14.2.1 How can I keep this format in excel? Problem now is that it changes it to date.