If at all possible I'd like to do this without VBA, and I'd like it to work cross-platform in Win Office as well as Mac Office. My cumbersome method currently does both, but it's . . . cumbersome. If ...
Hosted on MSN

Excel as a database

While Excel is renowned for its versatility in calculations and data visualization, it can also do the job just fine as a database. Small businesses, non-profits, and even departments within larger ...
With all the fancy software on the market, there’s a reason why many people are still trying to use the spreadsheet Microsoft Excel as a database, even though it’s not meant to be one, says Blist CEO ...
Excel is probably Microsoft’s most popular developer tool. With a built-in functional programming language that now supports lambdas and variables, Excel has become a tool that people build businesses ...