First time here? Check out the FAQ!

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! |

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 |

Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.