Ask Your Question

alex72gr's profile - activity

2019-03-22 22:11:15 +0200 received badge  Famous Question (source)
2019-01-28 18:26:49 +0200 received badge  Famous Question (source)
2019-01-12 13:28:23 +0200 received badge  Notable Question (source)
2019-01-06 15:12:09 +0200 received badge  Popular Question (source)
2019-01-05 19:25:32 +0200 marked best answer Timetable with Calc

Hello! I create the timetable for my school using LibreOffice Calc. My school has private-like lessons, i.e. lessons with one student (or sometimes a couple of students) per teacher (and per hour). So, in the spreadsheet I assign for each student the corresponding teacher. Please take a look on the sample file (attachment). The upper part is the timetable that I work on (timetable per student), and the lower part is a "automatic" representation of each teacher's schedule. "X" denotes that the student is not available on this specific hour (time slot). The schedule of the teachers is "read" from the students timetable with a function (combination of if and countif). What I need: when a teacher is impossible to have lesson for a specific hour, I need an "X" to be displayed in this specific hour on the teacher's schedule (lower part of the spreadsheet) AUTOMATICALLY. I mean that I need some kind of function in these cells that could read for each one of the teachers, if there is an available student for the specific hour. If there is no student available, I need the cell on the teachers schedule to have an "X". For example take a look on the teacher "Mary", Monday 2nd hour. It's impossible for her to have a lesson because none of her students (neither STUDENT_02, nor STUDENT_09 are available on this specific hour). So, the corresponding cell on the lower part (Monday, 2nd hour for Mary, at the lower part of the spreadsheet, should have an "X", which should be placed automatically). Is there any way to do it? Thanks a lot!

C:\fakepath\timetable_sample.ods

2019-01-05 19:25:32 +0200 received badge  Scholar (source)
2019-01-05 11:06:27 +0200 commented question Exclude strings in parentheses with SUMPRODUCT

Thank you! :) I think that I should wait for the release of v6.2. Up until then, I'll use my formula.

2019-01-05 01:06:15 +0200 commented question Exclude strings in parentheses with SUMPRODUCT

I thought of a solution... =SUMPRODUCT(AA19:BX19<>"",AA19:BX19<>"X",AA19:BX19<>G19,AA19:BX19<>L1

2019-01-04 22:19:52 +0200 asked a question Exclude strings in parentheses with SUMPRODUCT

Exclude strings in parentheses with SUMPRODUCT Hello! I have the following formula : =SUMPRODUCT(AA19:BX19<>"",AA1

2019-01-04 20:48:57 +0200 commented answer Timetable "transformation" (pivot tables..?)

Thank you for responding! I'm going to check your file little later... Maybe... for a fully automatic transformation, wr

2019-01-04 17:12:28 +0200 received badge  Popular Question (source)
2019-01-04 11:31:28 +0200 asked a question Timetable "transformation" (pivot tables..?)

Timetable "transformation" (pivot tables..?) C:\fakepath\timetable_transformation_sample.ods Hello! I have prepared a t

2019-01-03 22:10:24 +0200 commented answer Timetable with Calc

Thank you Lupp! Your approach for two (or more students) per teacher (and per hour) is fine. Actually, this is what happ

2019-01-03 12:25:02 +0200 commented answer Timetable with Calc

Lupp, after watching some tutorials on YouTube for spreadsheets, I realized that my mistake was that I should use a spec

2019-01-02 22:43:11 +0200 commented answer Timetable with Calc

Sorry, I was editing your file (copy -> paste) for experimenting, and I used my (edited) file... You are right, there

2019-01-02 22:39:30 +0200 commented answer Timetable with Calc

Sorry, I was editing the file (copy -> paste) for experimenting, and I used my (edited) file... You are right, there

2019-01-02 20:20:03 +0200 commented answer Timetable with Calc

Lupp, a question about the enhanced demonstration file (Edit1 2019-01-01 23:48 CET)... The cell F41 has the following fo

2019-01-02 15:18:52 +0200 commented answer Timetable with Calc

Wow! I just checked the new file. More than GREAT, and much more than I asked... One trillion thanks!!!

2019-01-02 10:12:04 +0200 commented answer Timetable with Calc

Hello again! Lupp, I checked your formula again. Unfortunately, what I can understand is just that it works. I need to r

2019-01-02 10:11:12 +0200 commented answer Timetable with Calc

Hello again! Lupp, I checked your formula again. Unfortunately, what I can understand is just that it works. This form o

2019-01-02 10:07:52 +0200 received badge  Notable Question (source)
2019-01-02 02:50:23 +0200 marked best answer Calc: Number of cells which don't have any of a set of values

My problem:

I have a spreadsheet with quite much information. I need to check a large number of rows (actually I need to check each one of them separately). Some cells are empty (no value), some others have the character (value) "X", and some other have string values. So, I what I need to check for every single row (or more precisely, for a specific range of every single row) is how many cells: 1) are not empty AND 2) do not the have the value (character) "X" AND 3) do not have the any of the (string) values of three specific cells of my spreadsheet.For example, if I need to check the row 7 (range F7:Y7) and I need to know how many cells are not empty AND do not have the value (character) "X" AND do not have any of the values (strings) of the cells A7, B7 and C7, which formula should I use? I think that I should use the COUNTIF function, but I'm not sure what I should do...

Thanks in advance!

2019-01-02 01:13:56 +0200 received badge  Notable Question (source)
2019-01-02 01:12:00 +0200 received badge  Notable Question (source)
2019-01-02 01:11:15 +0200 received badge  Supporter (source)
2019-01-02 01:07:30 +0200 commented answer Timetable with Calc

Oh! I got your file! GREAT!!! I'm going to check again your formula tomorrow. To be honest, I can't understand how it wo

2019-01-02 01:07:04 +0200 commented answer Timetable with Calc

Oh! I got your file! GREAT!!! I'm going to check again your formula tomorrow. No be honest, I can't understand how it wo

2019-01-01 23:52:43 +0200 commented answer Timetable with Calc

Thank you again! I'm looking forward to checking your new formulas and the functionality of the spreadsheet.

2019-01-01 23:33:45 +0200 commented answer Timetable with Calc

The second "appearance" of JHN was my mistake... :D I would like to check your other variant. I didn't really understand

2019-01-01 23:23:56 +0200 received badge  Popular Question (source)
2019-01-01 22:25:22 +0200 commented answer Timetable with Calc

Your solution works as well! Thank you so much!

2019-01-01 22:23:47 +0200 commented answer Timetable with Calc

I checked your file. It works! Thank you! I just need to see carefully (and understand) the combination of functions you

2019-01-01 18:55:28 +0200 edited question Timetable with Calc

Timetable with Calc Hello! I create the timetable for my school using LibreOffice Calc. My school has private-like lesso

2019-01-01 18:55:03 +0200 asked a question Timetable with Calc

Timetable with Calc Hello! I create the timetable for my school using LibreOffice Calc. My schools has private-like less

2018-12-26 14:35:01 +0200 received badge  Popular Question (source)
2018-12-25 21:45:19 +0200 commented question Multiple AutoFilters

I do so when I apply a filter. Otherwise the filter will not work at all. The problem is 1) adding a new filter (for exa

2018-12-25 21:45:19 +0200 received badge  Commentator
2018-12-25 12:35:06 +0200 asked a question Multiple AutoFilters

Multiple AutoFilters Hello! 1) In my spreadsheet I have created an autofilter including multiple columns. Each column ha

2018-12-15 16:23:06 +0200 commented answer "Reference" Cells for COUNTIF (Calc)

Thanks a lot!

2018-12-15 15:38:24 +0200 commented answer "Reference" Cells for COUNTIF (Calc)

Thanks again! Some further details: My school has many private-like musical instrument lessons. This means one teacher t

2018-12-15 15:21:35 +0200 received badge  Popular Question (source)
2018-12-15 14:52:03 +0200 commented answer "Reference" Cells for COUNTIF (Calc)

Thank you for your answer!

2018-12-15 14:38:43 +0200 commented answer "Reference" Cells for COUNTIF (Calc)

Thanks you for your answer!

2018-12-15 14:38:04 +0200 commented answer "Reference" Cells for COUNTIF (Calc)

Thank you both for your answers! It seems that you are really experienced users! The problem is that I use this spreadsh

2018-12-15 13:23:32 +0200 commented answer "Reference" Cells for COUNTIF (Calc)

Hello JohnSUN! The other columns of my spreadsheet carry other types of information. For example, while column D carries

2018-12-15 13:23:19 +0200 commented answer "Reference" Cells for COUNTIF (Calc)

Hello JohnSUN! The other columns of my spreadsheet carry other types of information. For example, while column D carries

2018-12-15 11:31:43 +0200 commented question "Reference" Cells for COUNTIF (Calc)

Thank you both for your answer and your joke! :-)

2018-12-15 10:34:49 +0200 asked a question "Reference" Cells for COUNTIF (Calc)

"Reference" Cells for COUNTIF (Calc) Hello! I have a spreadsheet with much information about my school. Specifically spe

2018-11-23 23:40:12 +0200 received badge  Enthusiast
2018-11-11 14:41:09 +0200 commented answer Scripting language for Calc

Thank you for responding! I checked you Demo file. Unfortunately, I can't understand how Basic works (I think than mean