Forum Widgets
Latest Discussions
How XLOOKUP arguments apply in this case
I'm not an Excel newbie, but I have never had cause to use XLOOKUP, INDEX, or MATCH before. I'm not understanding how the xlookup arguments would apply in my case or if index/match would be better. I have an array with months as my row headings and dates as my column headings. The array itself is filled with number of pages read each day. I'm trying to have a cell indicating on which date I did the maximum amount of reading. So I want to start with the max value of my array and return the month (row) and date (column) heading using xlookup. Whether those are in one cell or two, doesn't so much matter - it's a hobby tracker, but no matter how I try and call this, I end up with a value error So for example, I would want this to return January 3rd. Every example I'm finding seems to show how to input Jan 3rd and return the value 758. What am I missing to look this up the other way around? Should I be using index or match instead?
Filtering an Array based on a list of Criteria
I have an array that tracks every project that every project manager, project engineer, and superintendent is on and I am trying to set up a function to search through a single list of names and return just their projects. The PM, PE, and SUP on the array all have their own columns since there can be 1 of each on a single project. and the list im pulling from is within a single separate column pulling on the names I select. I have had success pulling from one column at a time using a FILTER(ISNUMBER(MATCH)) function but I cant get it to search and return all values from all three columns. Any thought on how to expand the search? Thank you!
Text to Column
Hello Everyone. I'm trying to split data into 2 columns. The original data is made up of cities and states: Notice that some items have a comma and others don't. Also, the cities states are different lengths. So, I cannot use a space or a comma as a delimiter. I'm trying to figure out how to separate them. I came up with this formula to add a colon so I can use the delimiter to separate them. The problem then becomes the fact that I have to count the number of spaces in each city to add the colon. Then, I have to copy and paste special as values. Also, notice that in New Orleans (for example), it keeps the comma: One more issue, if I get a new report with added cities and states, then I have to re-do the calculations. HELP!!!! Balta
Using calculated columns in pivot table
I already used calculated fields to get some datas in my pivot table. They're displayed as count or sum. I want to make a new calculated fields using a Sum of working time, divide it with the number of operations. How can I use the count and the sum ? Right now, it doesn't seem to use the sum nor the count : Here I want Sum of MBTF to be : Sum of working time/ Count of Stop but the values in Sum of MTBF seems to use the values in Stops (they are dispalyed in my original table as 6/7 numbers, but I used the function count to only get the number of occurences). I believe that's the thing causing my Sum of MTBF to show 1.68E-07 numbers ( for the first line it should be 52.001) : How can I get to have a column displaying the right values (52.001, and others for each line) ? Thank you in advance for your help !
File always corrupt
Anyone have the same problem with me? I use microsoft excel 365 on my mac. At the beginning everything alright, until i use formula and then save the file. When i want to re-open the file, the messagebox showed up "we found something wrong in your content...". It gives 2 option, yes and no. If i click no, the file wont open. If i click yes, the file open, the excel do the recovery, the file open but end up with all the formulas is gone, deleted by excel and just left the value. What should i do? Do the file can still be fixed?
